TidyFriday

Lisbeth, Kirstine & Marlene

Bee Colonies Lost

Data and variables

Code 
pacman::p_load(tidyverse, usmap, scales, ggpubr)
colony <- readr::read_csv('https://raw.githubusercontent.com/rfordatascience/tidytuesday/master/data/2022/2022-01-11/colony.csv')

knitr::kable(colony %>% 
  relocate(colony_lost, colony_added, .after = state))
year months state colony_lost colony_added colony_n colony_max colony_lost_pct colony_reno colony_reno_pct
2015 January-March Alabama 1800 2800 7000 7000 26 250 4
2015 January-March Arizona 4600 3400 35000 35000 13 2100 6
2015 January-March Arkansas 1500 1200 13000 14000 11 90 1
2015 January-March California 255000 250000 1440000 1690000 15 124000 7
2015 January-March Colorado 1500 200 3500 12500 12 140 1
2015 January-March Connecticut 870 290 3900 3900 22 NA NA
2015 January-March Florida 42000 54000 305000 315000 13 25000 8
2015 January-March Georgia 14500 47000 104000 105000 14 9500 9
2015 January-March Hawaii 380 3400 10500 10500 4 760 7
2015 January-March Idaho 3700 2600 81000 88000 4 8000 9
2015 January-March Illinois 4200 2300 6000 10500 40 390 4
2015 January-March Indiana 2100 490 9000 9500 22 120 1
2015 January-March Iowa 3100 1700 12500 17500 18 270 2
2015 January-March Kansas 1600 450 4600 7000 23 70 1
2015 January-March Kentucky 4100 250 7500 10500 39 NA NA
2015 January-March Louisiana 8000 3100 51000 51000 16 6500 13
2015 January-March Maine 380 20 3100 6500 6 NA NA
2015 January-March Maryland 4100 1600 7500 10000 41 870 9
2015 January-March Massachusetts 1000 260 2900 4600 22 120 3
2015 January-March Michigan 11500 7500 16500 60000 19 2400 4
2015 January-March Minnesota 3700 690 28000 74000 5 530 1
2015 January-March Mississippi 8500 22000 34000 76000 11 7500 10
2015 January-March Missouri 2000 220 12000 13000 15 910 7
2015 January-March Montana 2200 1400 8500 36000 6 1100 3
2015 January-March Nebraska 2600 120 10000 31000 8 310 1
2015 January-March New Jersey 1100 570 6000 9000 12 1600 18
2015 January-March New Mexico 690 190 7000 7000 10 600 9
2015 January-March New York 6500 430 27000 30000 22 950 3
2015 January-March North Carolina 7000 6000 24000 26000 27 690 3
2015 January-March North Dakota 620 1800 57000 120000 1 530 NA
2015 January-March Ohio 10500 5000 18000 22000 48 3300 15
2015 January-March Oklahoma 6000 2600 9500 26000 23 260 1
2015 January-March Oregon 6500 4300 77000 87000 8 2400 3
2015 January-March Pennsylvania 6500 360 14000 21000 31 NA NA
2015 January-March South Carolina 2700 2700 17000 17500 15 1400 8
2015 January-March South Dakota 4600 8500 50000 97000 5 2800 3
2015 January-March Tennessee 2000 1000 9500 9500 21 190 2
2015 January-March Texas 26000 82000 191000 250000 10 51000 20
2015 January-March Utah 3300 2500 6000 24000 14 290 1
2015 January-March Vermont 700 1200 5500 5500 13 20 NA
2015 January-March Virginia 2500 800 8000 9000 28 460 5
2015 January-March Washington 14000 13500 52000 105000 13 9000 9
2015 January-March West Virginia 1800 570 4700 6000 30 60 1
2015 January-March Wisconsin 8000 3100 16500 29000 28 2500 9
2015 January-March Wyoming 2000 2000 5500 12000 17 1400 12
2015 January-March Other States 2080 870 3410 8990 23 150 2
2015 January-March United States 500020 546980 2824610 NA 18 270530 10
2015 April-June Alabama 860 1900 7500 7500 12 680 9
2015 April-June Arizona 5500 19500 33000 33000 17 7000 21
2015 April-June Arkansas 1900 11500 13500 13500 14 5500 41
2015 April-June California 104000 170000 1040000 1050000 10 285000 27
2015 April-June Colorado 1900 6000 12000 25000 8 3500 14
2015 April-June Connecticut 80 1100 3000 3000 3 150 5
2015 April-June Florida 35000 44000 210000 215000 16 24000 11
2015 April-June Georgia 23000 25000 114000 124000 19 19000 15
2015 April-June Hawaii 120 1100 13500 13500 1 1200 9
2015 April-June Idaho 6500 16500 62000 72000 9 10500 15
2015 April-June Illinois 1300 6000 9500 9500 14 1500 16
2015 April-June Indiana 1300 4900 8000 12500 10 4300 34
2015 April-June Iowa 1400 6500 12500 24000 6 3100 13
2015 April-June Kansas 670 2800 6000 7000 10 420 6
2015 April-June Kentucky 980 3600 7500 8500 12 1500 18
2015 April-June Louisiana 1800 6500 44000 45000 4 8000 18
2015 April-June Maine 3200 3500 4600 30000 11 700 2
2015 April-June Maryland 370 2600 8000 11000 3 710 7
2015 April-June Massachusetts 320 940 4100 14000 2 510 4
2015 April-June Michigan 9500 13500 58000 88000 11 5500 6
2015 April-June Minnesota 12500 20000 71000 125000 10 21000 17
2015 April-June Mississippi 11000 5500 89000 89000 12 10000 11
2015 April-June Missouri 500 1900 11500 12500 4 1800 14
2015 April-June Montana 4200 14000 36000 210000 2 33000 16
2015 April-June Nebraska 4100 15500 29000 68000 6 4600 7
2015 April-June New Jersey 1800 2100 8500 19000 10 2900 15
2015 April-June New Mexico 1000 1500 6500 8500 12 330 4
2015 April-June New York 1100 11000 24000 34000 3 1500 4
2015 April-June North Carolina 1800 5500 19500 23000 8 3300 14
2015 April-June North Dakota 29000 39000 121000 450000 6 61000 14
2015 April-June Ohio 2100 10000 17500 19000 11 6000 32
2015 April-June Oklahoma 2200 5500 25000 27000 8 2200 8
2015 April-June Oregon 5500 14500 82000 95000 6 9500 10
2015 April-June Pennsylvania 1600 8500 15500 19000 8 2600 14
2015 April-June South Carolina 950 1100 17500 18500 5 2000 11
2015 April-June South Dakota 21000 27000 100000 290000 7 23000 8
2015 April-June Tennessee 730 3600 7500 7500 10 920 12
2015 April-June Texas 33000 76000 305000 315000 11 94000 30
2015 April-June Utah 3400 10000 24000 27000 13 3900 14
2015 April-June Vermont 100 580 6000 6000 2 50 1
2015 April-June Virginia 270 2100 7500 7500 4 430 6
2015 April-June Washington 5000 15000 105000 127000 4 13000 10
2015 April-June West Virginia 570 2900 4700 4700 12 590 13
2015 April-June Wisconsin 4600 10000 25000 65000 7 5500 9
2015 April-June Wyoming 3200 7500 12000 25000 13 5000 20
2015 April-June Other States 1940 4140 8600 11200 17 1960 18
2015 April-June United States 352860 661860 2849500 NA 12 692850 24
2015 July-September Alabama 1400 160 8500 9000 16 260 3
2015 July-September Arizona 6000 4300 40000 40000 15 15500 39
2015 July-September Arkansas 9000 500 23000 30000 30 210 1
2015 July-September California 76000 40000 730000 800000 10 93000 12
2015 July-September Colorado 4500 1400 29000 30000 15 1400 5
2015 July-September Connecticut 50 190 3700 3700 1 440 12
2015 July-September Florida 36000 37000 164000 220000 16 29000 13
2015 July-September Georgia 13000 19500 108000 110000 12 15500 14
2015 July-September Hawaii 2700 1200 14500 14500 19 5500 38
2015 July-September Idaho 14000 5500 80000 128000 11 11500 9
2015 July-September Illinois 1400 1300 14000 14000 10 1100 8
2015 July-September Indiana 1600 1400 15000 15000 11 420 3
2015 July-September Iowa 3000 640 29000 37000 8 680 2
2015 July-September Kansas 1000 100 9000 9500 11 160 2
2015 July-September Kentucky 1300 170 10000 10000 13 550 6
2015 July-September Louisiana 2000 2300 50000 55000 4 1800 3
2015 July-September Maine 450 410 6000 6000 8 140 2
2015 July-September Maryland 680 730 7000 7500 9 70 1
2015 July-September Massachusetts 560 290 7500 7500 8 400 5
2015 July-September Michigan 7000 3300 89000 89000 8 3800 4
2015 July-September Minnesota 32000 640 133000 136000 24 2300 2
2015 July-September Mississippi 3500 260 23000 34000 10 110 NA
2015 July-September Missouri 1200 700 14000 14000 9 630 5
2015 July-September Montana 10500 3200 140000 156000 7 10000 6
2015 July-September Nebraska 6000 500 67000 77000 8 6000 8
2015 July-September New Jersey 210 190 18500 18500 1 500 3
2015 July-September New Mexico 1600 1300 6500 6500 25 650 10
2015 July-September New York 6500 4400 44000 47000 14 7000 15
2015 July-September North Carolina 2900 2500 24000 24000 12 1100 5
2015 July-September North Dakota 93000 11000 460000 500000 19 22000 4
2015 July-September Ohio 1900 2300 23000 23000 8 880 4
2015 July-September Oklahoma 230 160 19500 22000 1 190 1
2015 July-September Oregon 8500 8000 68000 100000 9 21000 21
2015 July-September Pennsylvania 1800 1800 25000 25000 7 2400 10
2015 July-September South Carolina 2000 880 12000 12000 17 580 5
2015 July-September South Dakota 53000 2100 295000 295000 18 13000 4
2015 July-September Tennessee 1200 500 10000 10000 12 350 4
2015 July-September Texas 16500 5500 76000 136000 12 4800 4
2015 July-September Utah 8000 1400 31000 36000 22 2200 6
2015 July-September Vermont 40 30 6000 6500 1 20 NA
2015 July-September Virginia 680 520 8000 8000 9 220 3
2015 July-September Washington 11500 1800 84000 97000 12 20000 21
2015 July-September West Virginia 300 300 7000 7000 4 270 4
2015 July-September Wisconsin 9000 1300 60000 62000 15 4300 7
2015 July-September Wyoming 2500 270 29000 35000 7 440 1
2015 July-September Other States 900 1050 12180 12280 7 700 6
2015 July-September United States 457100 172990 3132880 NA 15 303070 10
2015 October-December Alabama 610 80 8000 8000 8 60 1
2015 October-December Arizona 12000 3000 36000 39000 31 16000 41
2015 October-December Arkansas 2400 1900 23000 27000 9 NA NA
2015 October-December California 149000 39000 750000 1260000 12 75000 6
2015 October-December Colorado 2500 3400 24000 24000 10 NA NA
2015 October-December Connecticut 210 40 3200 3200 7 70 2
2015 October-December Florida 37000 30000 220000 260000 14 28000 11
2015 October-December Georgia 18000 4400 110000 121000 15 1900 2
2015 October-December Hawaii 690 2700 13000 13000 5 760 6
2015 October-December Idaho 22000 5500 121000 145000 15 5500 4
2015 October-December Illinois 690 NA 14000 14000 5 30 NA
2015 October-December Indiana 1100 140 11500 11500 10 NA NA
2015 October-December Iowa 4300 40 35000 35000 12 30 NA
2015 October-December Kansas 3400 50 8500 8500 40 20 NA
2015 October-December Kentucky 1100 20 8500 8500 13 10 NA
2015 October-December Louisiana 4900 1100 55000 71000 7 2400 3
2015 October-December Maine 60 530 4700 4700 1 20 NA
2015 October-December Maryland 730 NA 7500 9500 8 NA NA
2015 October-December Massachusetts 260 30 4500 4500 6 30 1
2015 October-December Michigan 9000 210 67000 73000 12 1600 2
2015 October-December Minnesota 10000 600 104000 105000 10 40 NA
2015 October-December Mississippi 1500 500 31000 34000 4 230 1
2015 October-December Missouri 690 30 13500 13500 5 40 NA
2015 October-December Montana 10000 1000 116000 123000 8 80 NA
2015 October-December Nebraska 7000 10 72000 73000 10 5500 8
2015 October-December New Jersey 270 20 8000 8500 3 10 NA
2015 October-December New Mexico 290 290 6000 6000 5 30 1
2015 October-December New York 4000 260 45000 45000 9 10 NA
2015 October-December North Carolina 2200 510 22000 22000 10 70 NA
2015 October-December North Dakota 35000 2700 230000 275000 13 9000 3
2015 October-December Ohio 2400 200 19000 19000 13 140 1
2015 October-December Oklahoma 650 290 5000 10000 7 60 1
2015 October-December Oregon 8500 200 100000 114000 8 1400 1
2015 October-December Pennsylvania 2500 1300 22000 23000 11 6500 28
2015 October-December South Carolina 2200 640 10000 17500 13 1000 6
2015 October-December South Dakota 9000 2400 194000 205000 4 NA NA
2015 October-December Tennessee 1100 70 8500 10000 11 420 4
2015 October-December Texas 25000 13000 125000 250000 10 2000 1
2015 October-December Utah 1900 120 28000 28000 7 100 NA
2015 October-December Vermont 940 10 6500 6500 15 10 NA
2015 October-December Virginia 750 NA 7500 7500 10 350 5
2015 October-December Washington 6500 330 87000 89000 7 170 NA
2015 October-December West Virginia 610 190 7000 7000 9 140 2
2015 October-December Wisconsin 6500 210 48000 48000 14 10 NA
2015 October-December Wyoming 1300 30 24000 25000 5 NA NA
2015 October-December Other States 1630 100 11360 12560 13 50 NA
2015 October-December United States 412380 117150 2874760 NA 14 158790 6
2016 January-March Alabama 1700 1200 7500 7500 23 180 2
2016 January-March Arizona 4700 2200 30000 30000 16 960 3
2016 January-March Arkansas 5000 4700 27000 27000 19 2200 8
2016 January-March California 210000 175000 1140000 1410000 15 63000 5
2016 January-March Colorado 570 NA 6000 7000 8 20 NA
2016 January-March Connecticut 270 70 2700 2700 10 10 NA
2016 January-March Florida 45000 36000 245000 265000 17 18500 7
2016 January-March Georgia 20000 28000 100000 100000 20 6000 6
2016 January-March Hawaii 280 570 15000 15000 2 1100 7
2016 January-March Idaho 6500 5500 90000 97000 7 6500 7
2016 January-March Illinois 1300 470 7000 7500 17 20 NA
2016 January-March Indiana 770 40 6500 6500 12 NA NA
2016 January-March Iowa 3200 90 16500 16500 19 NA NA
2016 January-March Kansas 980 NA 4700 4700 21 200 4
2016 January-March Kentucky 1300 110 7000 7000 19 70 1
2016 January-March Louisiana 9500 7500 68000 69000 14 5500 8
2016 January-March Maine 170 NA 2200 3700 5 NA NA
2016 January-March Maryland 1400 40 6500 6500 22 20 NA
2016 January-March Massachusetts 370 120 3000 3000 12 330 11
2016 January-March Michigan 5000 2300 25000 37000 14 110 NA
2016 January-March Minnesota 6000 4400 37000 39000 15 10 NA
2016 January-March Mississippi 6500 11000 24000 77000 8 1700 2
2016 January-March Missouri 1200 930 11500 11500 10 290 3
2016 January-March Montana 840 11500 15500 48000 2 NA NA
2016 January-March Nebraska 330 40 10500 21000 2 30 NA
2016 January-March New Jersey 1000 80 8500 8500 12 40 1
2016 January-March New Mexico 1700 10 6000 6500 26 70 1
2016 January-March New York 4000 140 31000 31000 13 1400 5
2016 January-March North Carolina 2500 80 18500 24000 10 840 4
2016 January-March North Dakota 17000 NA 82000 173000 10 NA NA
2016 January-March Ohio 4200 760 16000 16000 26 100 1
2016 January-March Oklahoma 2900 60 6000 6000 48 510 9
2016 January-March Oregon 2800 3800 70000 92000 3 1800 2
2016 January-March Pennsylvania 2900 220 12500 12500 23 340 3
2016 January-March South Carolina 3400 2100 16500 16500 21 1800 11
2016 January-March South Dakota 770 30 30000 91000 1 NA NA
2016 January-March Tennessee 1700 100 9000 9000 19 150 2
2016 January-March Texas 29000 73000 240000 290000 10 42000 15
2016 January-March Utah 1700 710 12000 12500 14 100 1
2016 January-March Vermont 410 NA 5500 5500 8 NA NA
2016 January-March Virginia 1100 500 6500 6500 17 130 2
2016 January-March Washington 13000 4200 78000 135000 10 2000 2
2016 January-March West Virginia 1700 NA 6500 7500 23 10 NA
2016 January-March Wisconsin 2900 530 22000 23000 13 NA NA
2016 January-March Wyoming 340 NA 2700 5000 7 NA NA
2016 January-March Other States 900 60 7290 7890 11 10 NA
2016 January-March United States 428800 378160 2594590 NA 17 158050 6
2016 April-June Alabama 930 1200 8000 8000 12 690 9
2016 April-June Arizona 3700 14000 22000 23000 16 1600 7
2016 April-June Arkansas 3400 12000 24000 24000 14 1600 7
2016 April-June California 108000 240000 1110000 1150000 9 185000 16
2016 April-June Colorado 1800 9000 9500 29000 6 680 2
2016 April-June Connecticut 100 390 2500 2500 4 60 2
2016 April-June Florida 29000 43000 240000 240000 12 21000 9
2016 April-June Georgia 11000 17500 108000 111000 10 3600 3
2016 April-June Hawaii 830 870 13500 13500 6 NA NA
2016 April-June Idaho 6000 19000 60000 80000 8 5500 7
2016 April-June Illinois 740 2200 9000 9000 8 380 4
2016 April-June Indiana 220 2700 4300 7000 3 900 13
2016 April-June Iowa 2400 26000 10500 26000 9 760 3
2016 April-June Kansas 960 3000 4700 6000 16 900 15
2016 April-June Kentucky 450 2100 5500 6000 8 270 5
2016 April-June Louisiana 4300 10000 52000 53000 8 9500 18
2016 April-June Maine 4200 510 3600 25000 17 560 2
2016 April-June Maryland 320 2800 8000 9000 4 400 4
2016 April-June Massachusetts 300 1100 4200 8500 4 440 5
2016 April-June Michigan 7500 13500 40000 103000 7 3200 3
2016 April-June Minnesota 13000 24000 27000 126000 10 4200 3
2016 April-June Mississippi 3700 9000 85000 90000 4 61000 68
2016 April-June Missouri 770 1800 12000 12500 6 730 6
2016 April-June Montana 7000 25000 62000 157000 4 13500 9
2016 April-June Nebraska 6000 8000 19500 43000 14 28000 65
2016 April-June New Jersey 1500 1900 4200 18000 8 110 1
2016 April-June New Mexico 1400 2700 6500 6500 22 100 2
2016 April-June New York 4000 13500 31000 46000 9 1500 3
2016 April-June North Carolina 1600 10000 23000 24000 7 550 2
2016 April-June North Dakota 27000 23000 110000 530000 5 95000 18
2016 April-June Ohio 1700 6000 14000 16500 10 1100 7
2016 April-June Oklahoma 310 4000 12000 13000 2 10000 77
2016 April-June Oregon 4300 19000 77000 132000 3 16000 12
2016 April-June Pennsylvania 1300 6500 11000 14000 9 1100 8
2016 April-June South Carolina 1300 2200 12500 13500 10 410 3
2016 April-June South Dakota 11000 15000 51000 182000 6 13000 7
2016 April-June Tennessee 580 3900 8000 8000 7 200 3
2016 April-June Texas 36000 74000 340000 350000 10 54000 15
2016 April-June Utah 4800 12000 14500 25000 19 7000 28
2016 April-June Vermont 20 480 5000 6500 NA 30 NA
2016 April-June Virginia 230 2200 6000 6500 4 480 7
2016 April-June Washington 6000 21000 91000 143000 4 11500 8
2016 April-June West Virginia 990 2600 7000 7000 14 160 2
2016 April-June Wisconsin 5500 17500 18500 78000 7 3600 5
2016 April-June Wyoming 2600 7500 6500 27000 10 580 2
2016 April-June Other States 1070 3270 7970 15530 7 270 2
2016 April-June United States 329820 736920 2801470 NA 12 561160 20
2016 July-September Alabama 1200 440 8000 8000 15 50 1
2016 July-September Arizona 6000 3200 30000 32000 19 2600 8
2016 July-September Arkansas 1500 270 32000 32000 5 60 NA
2016 July-September California 82000 33000 740000 820000 10 78000 10
2016 July-September Colorado 6500 1100 33000 37000 18 740 2
2016 July-September Connecticut 270 890 3100 3100 9 180 6
2016 July-September Florida 25000 62000 200000 220000 11 14500 7
2016 July-September Georgia 13000 12500 102000 103000 13 2300 2
2016 July-September Hawaii 600 430 13500 13500 4 820 6
2016 July-September Idaho 13000 1900 79000 131000 10 2800 2
2016 July-September Illinois 1300 850 11000 11000 12 310 3
2016 July-September Indiana 600 450 9500 9500 6 550 6
2016 July-September Iowa 5500 10500 50000 50000 11 2400 5
2016 July-September Kansas 2600 310 8000 8000 33 190 2
2016 July-September Kentucky 1000 900 7500 7500 13 230 3
2016 July-September Louisiana 7000 2600 51000 60000 12 2100 4
2016 July-September Maine 420 240 5500 5500 8 140 3
2016 July-September Maryland 200 400 7000 7000 3 20 NA
2016 July-September Massachusetts 530 450 9500 9500 6 40 NA
2016 July-September Michigan 15000 11000 108000 108000 14 9500 9
2016 July-September Minnesota 26000 1300 132000 138000 19 1900 1
2016 July-September Mississippi 3300 750 19000 20000 17 740 4
2016 July-September Missouri 650 480 13500 13500 5 170 1
2016 July-September Montana 11500 4100 147000 158000 7 6500 4
2016 July-September Nebraska 8500 390 45000 47000 18 27000 57
2016 July-September New Jersey 270 120 18000 18000 2 80 NA
2016 July-September New Mexico 1100 2000 6500 6500 17 1000 15
2016 July-September New York 10000 1900 56000 56000 18 800 1
2016 July-September North Carolina 1400 1400 25000 25000 6 1200 5
2016 July-September North Dakota 71000 25000 510000 550000 13 104000 19
2016 July-September Ohio 1600 980 21000 21000 8 630 3
2016 July-September Oklahoma 560 30 3700 3700 15 30 1
2016 July-September Oregon 7500 2900 107000 112000 7 4300 4
2016 July-September Pennsylvania 1300 680 19000 22000 6 780 4
2016 July-September South Carolina 920 990 13000 13500 7 50 NA
2016 July-September South Dakota 25000 4200 178000 191000 13 9500 5
2016 July-September Tennessee 950 340 10000 10000 10 290 3
2016 July-September Texas 12000 12500 129000 143000 8 810 1
2016 July-September Utah 3200 1200 27000 33000 10 120 NA
2016 July-September Vermont 400 170 6500 6500 6 50 1
2016 July-September Virginia 810 460 8000 8000 10 360 5
2016 July-September Washington 5000 7500 57000 74000 7 2000 3
2016 July-September West Virginia 190 130 7500 7500 3 220 3
2016 July-September Wisconsin 12000 880 71000 75000 16 640 1
2016 July-September Wyoming 7000 1800 32000 40000 18 1000 3
2016 July-September Other States 1920 1690 11880 11890 16 430 4
2016 July-September United States 397290 217320 3181180 NA 12 282130 9
2016 October-December Alabama 610 50 7000 7000 9 10 NA
2016 October-December Arizona 6500 4600 29000 31000 21 3100 10
2016 October-December Arkansas 2500 20 28000 28000 9 10 NA
2016 October-December California 205000 40000 770000 1330000 15 35000 3
2016 October-December Colorado 4500 2500 30000 30000 15 NA NA
2016 October-December Connecticut 240 NA 3100 3100 8 NA NA
2016 October-December Florida 41000 31000 255000 300000 14 11500 4
2016 October-December Georgia 11000 12000 96000 112000 10 450 NA
2016 October-December Hawaii 970 60 13500 13500 7 840 6
2016 October-December Idaho 15500 5000 121000 143000 11 420 NA
2016 October-December Illinois 720 NA 9000 9000 8 NA NA
2016 October-December Indiana 1200 20 7500 7500 16 NA NA
2016 October-December Iowa 4700 NA 54000 54000 9 20 NA
2016 October-December Kansas 1300 200 5000 5000 26 NA NA
2016 October-December Kentucky 950 60 7500 7500 13 80 1
2016 October-December Louisiana 2000 250 48000 57000 4 340 1
2016 October-December Maine 280 NA 3500 3500 8 NA NA
2016 October-December Maryland 500 20 7500 9500 5 30 NA
2016 October-December Massachusetts 740 NA 8000 8000 9 NA NA
2016 October-December Michigan 12500 10 101000 101000 12 130 NA
2016 October-December Minnesota 13500 NA 113000 114000 12 NA NA
2016 October-December Mississippi 2400 330 17500 30000 8 60 NA
2016 October-December Missouri 590 1400 9000 9000 7 640 7
2016 October-December Montana 16000 2700 124000 124000 13 NA NA
2016 October-December Nebraska 4300 190 37000 37000 12 NA NA
2016 October-December New Jersey 340 400 12000 12000 3 NA NA
2016 October-December New Mexico 1600 1100 7000 7000 23 20 NA
2016 October-December New York 9000 240 48000 49000 18 130 NA
2016 October-December North Carolina 5500 220 25000 25000 22 50 NA
2016 October-December North Dakota 44000 13500 385000 390000 11 2500 1
2016 October-December Ohio 2100 20 19500 19500 11 140 1
2016 October-December Oklahoma 2700 120 3100 44000 6 30 NA
2016 October-December Oregon 9500 1500 98000 124000 8 1000 1
2016 October-December Pennsylvania 3100 120 21000 21000 15 180 1
2016 October-December South Carolina 1300 760 12000 17000 8 370 2
2016 October-December South Dakota 11000 NA 146000 146000 8 2400 2
2016 October-December Tennessee 840 120 9000 9000 9 10 NA
2016 October-December Texas 39000 2200 136000 310000 13 650 NA
2016 October-December Utah 1600 440 30000 30000 5 50 NA
2016 October-December Vermont 260 20 6500 6500 4 10 NA
2016 October-December Virginia 730 230 7000 7000 10 10 NA
2016 October-December Washington 9000 3100 65000 97000 9 130 NA
2016 October-December West Virginia 1000 80 7500 7500 13 60 1
2016 October-December Wisconsin 7500 10 59000 59000 13 20 NA
2016 October-December Wyoming 2200 50 25000 27000 8 NA NA
2016 October-December Other States 580 20 6360 6460 9 NA NA
2016 October-December United States 502350 124660 3032060 NA 17 60390 2
2017 January-March Alabama 1600 570 7000 7000 23 730 10
2017 January-March Arizona 6000 2900 31000 32000 19 NA NA
2017 January-March Arkansas 3500 430 18000 20000 18 190 1
2017 January-March California 172000 215000 1150000 1440000 12 92000 6
2017 January-March Colorado 1100 100 9500 21000 5 NA NA
2017 January-March Connecticut 380 100 3100 3100 12 110 4
2017 January-March Florida 30000 80000 260000 265000 11 33000 12
2017 January-March Georgia 14000 36000 123000 125000 11 21000 17
2017 January-March Hawaii 190 510 13000 13000 1 50 NA
2017 January-March Idaho 8500 2000 95000 99000 9 280 NA
2017 January-March Illinois 2900 3100 11000 11000 26 150 1
2017 January-March Indiana 1900 1700 7000 7500 25 70 1
2017 January-March Iowa 3000 70 10000 15500 19 NA NA
2017 January-March Kansas 1000 930 3800 3800 26 380 10
2017 January-March Kentucky 1300 950 6500 7000 19 430 6
2017 January-March Louisiana 2700 11000 44000 47000 6 1900 4
2017 January-March Maine 1000 100 2700 3100 32 NA NA
2017 January-March Maryland 2100 770 9000 9000 23 260 3
2017 January-March Massachusetts 1500 120 3300 3300 45 110 3
2017 January-March Michigan 5000 600 29000 59000 8 130 NA
2017 January-March Minnesota 3500 3300 27000 41000 9 NA NA
2017 January-March Mississippi 2600 23000 31000 68000 4 7500 11
2017 January-March Missouri 1200 400 6500 7500 16 10 NA
2017 January-March Montana 470 3100 18500 46000 1 6000 13
2017 January-March Nebraska 750 120 7500 13000 6 NA NA
2017 January-March New Jersey 490 10 6000 6500 8 NA NA
2017 January-March New Mexico 2100 3600 5500 5500 38 NA NA
2017 January-March New York 6000 520 32000 33000 18 NA NA
2017 January-March North Carolina 2500 3700 16000 23000 11 1200 5
2017 January-March North Dakota 640 1100 50000 123000 1 10 NA
2017 January-March Ohio 4400 1300 15500 17500 25 530 3
2017 January-March Oklahoma 550 9500 26000 26000 2 1600 6
2017 January-March Oregon 8000 7500 71000 90000 9 1400 2
2017 January-March Pennsylvania 4200 810 17000 18000 23 410 2
2017 January-March South Carolina 1600 4700 17000 17500 9 970 6
2017 January-March South Dakota 2700 1500 21000 48000 6 440 1
2017 January-March Tennessee 1600 1500 8500 8500 19 160 2
2017 January-March Texas 35000 148000 270000 330000 11 68000 21
2017 January-March Utah 2700 2900 16000 18500 15 60 NA
2017 January-March Vermont 440 NA 6500 6500 7 NA NA
2017 January-March Virginia 1400 1900 8000 8000 18 280 4
2017 January-March Washington 9000 8500 68000 104000 9 NA NA
2017 January-March West Virginia 800 450 5500 8000 10 100 1
2017 January-March Wisconsin 4400 450 17000 22000 20 70 NA
2017 January-March Wyoming 3600 1300 6500 17000 21 NA NA
2017 January-March Other States 1540 130 6190 6490 24 50 1
2017 January-March United States 361850 586240 2615590 NA 14 239580 9
2017 April-June Alabama 440 1200 6500 6500 7 500 8
2017 April-June Arizona 2600 12500 22000 22000 12 3000 14
2017 April-June Arkansas 1900 5000 17000 17000 11 1300 8
2017 April-June California 82000 210000 1140000 1180000 7 235000 20
2017 April-June Colorado 3500 5500 16500 29000 12 7500 26
2017 April-June Connecticut 140 2200 3000 3000 5 350 12
2017 April-June Florida 25000 40000 245000 250000 10 50000 20
2017 April-June Georgia 10500 21000 125000 142000 7 33000 23
2017 April-June Hawaii 60 520 12000 12000 1 910 8
2017 April-June Idaho 9500 24000 61000 78000 12 31000 40
2017 April-June Illinois 1200 3600 12000 12500 10 1600 13
2017 April-June Indiana 1200 3000 7500 11000 11 510 5
2017 April-June Iowa 2000 24000 12500 23000 9 3900 17
2017 April-June Kansas 380 2500 4400 4900 8 890 18
2017 April-June Kentucky 560 2900 6500 7000 8 600 9
2017 April-June Louisiana 2600 4600 56000 56000 5 9000 16
2017 April-June Maine 910 790 2200 40000 2 1400 4
2017 April-June Maryland 190 3200 8000 9500 2 930 10
2017 April-June Massachusetts 130 1900 1900 8000 2 490 6
2017 April-June Michigan 4600 22000 55000 79000 6 11500 15
2017 April-June Minnesota 5000 18500 34000 128000 4 9000 7
2017 April-June Mississippi 3800 5500 89000 89000 4 42000 47
2017 April-June Missouri 260 1700 7000 7500 3 1000 13
2017 April-June Montana 3800 15000 46000 134000 3 20000 15
2017 April-June Nebraska 640 6000 8500 63000 1 39000 62
2017 April-June New Jersey 430 1600 6000 21000 2 660 3
2017 April-June New Mexico 1700 2300 7000 7500 23 3900 52
2017 April-June New York 1300 16000 25000 41000 3 7500 18
2017 April-June North Carolina 1600 3900 24000 25000 6 2700 11
2017 April-June North Dakota 10500 19500 112000 385000 3 37000 10
2017 April-June Ohio 1100 8000 13500 14500 8 2500 17
2017 April-June Oklahoma 200 6500 25000 25000 1 1600 6
2017 April-June Oregon 5000 18000 84000 108000 5 24000 22
2017 April-June Pennsylvania 510 7000 15000 16500 3 2200 13
2017 April-June South Carolina 870 1900 20000 20000 4 3700 19
2017 April-June South Dakota 6000 10000 34000 152000 4 20000 13
2017 April-June Tennessee 1100 2600 8500 9000 12 1300 14
2017 April-June Texas 18000 43000 345000 345000 5 148000 43
2017 April-June Utah 2300 14500 19000 35000 7 10500 30
2017 April-June Vermont 170 390 6000 8000 2 190 2
2017 April-June Virginia 1000 3100 8500 9000 11 1100 12
2017 April-June Washington 6500 36000 89000 132000 5 21000 16
2017 April-June West Virginia 340 3400 7500 7500 5 2500 33
2017 April-June Wisconsin 2900 13000 18000 65000 4 6500 10
2017 April-June Wyoming 1100 4800 15000 30000 4 4100 14
2017 April-June Other States 150 870 5530 7040 2 840 12
2017 April-June United States 225680 653470 2886030 NA 8 806170 28
2017 July-September Alabama 900 690 7000 9500 9 530 6
2017 July-September Arizona 4100 5000 26000 26000 16 3200 12
2017 July-September Arkansas 6000 4400 29000 29000 21 410 1
2017 July-September California 67000 73000 590000 670000 10 74000 11
2017 July-September Colorado 4300 2900 35000 42000 10 6410 15
2017 July-September Connecticut 130 50 3500 3500 4 20 1
2017 July-September Florida 39000 39000 176000 180000 22 42000 23
2017 July-September Georgia 15500 19000 121000 122000 13 23000 19
2017 July-September Hawaii 1100 430 15000 15000 7 20 NA
2017 July-September Idaho 12000 9000 89000 116000 10 16500 14
2017 July-September Illinois 1100 710 13000 13000 8 1200 9
2017 July-September Indiana 930 420 13000 13000 7 740 6
2017 July-September Iowa 2200 2100 40000 43000 5 4000 9
2017 July-September Kansas 1700 1400 7000 7000 24 1000 14
2017 July-September Kentucky 1600 450 9000 9000 18 700 8
2017 July-September Louisiana 13500 14500 64000 64000 21 34000 53
2017 July-September Maine 400 210 5500 6000 7 290 5
2017 July-September Maryland 1600 1300 8500 8500 19 600 7
2017 July-September Massachusetts 760 790 9000 9000 8 460 5
2017 July-September Michigan 17500 4300 103000 109000 16 11500 11
2017 July-September Minnesota 20000 1900 136000 136000 15 2200 2
2017 July-September Mississippi 2900 250 24000 24000 12 230 1
2017 July-September Missouri 580 320 9000 9000 6 310 3
2017 July-September Montana 18500 3100 154000 161000 11 23000 14
2017 July-September Nebraska 3700 880 46000 47000 8 13500 29
2017 July-September New Jersey 420 280 16000 16000 3 110 1
2017 July-September New Mexico 2500 1800 8500 8500 29 200 2
2017 July-September New York 6500 3100 59000 59000 11 9000 15
2017 July-September North Carolina 3300 4100 26000 27000 12 2900 11
2017 July-September North Dakota 48000 24000 470000 490000 10 100000 20
2017 July-September Ohio 1800 1100 23000 23000 8 1800 8
2017 July-September Oklahoma 510 80 4400 4400 12 270 6
2017 July-September Oregon 13500 7500 94000 101000 13 28000 28
2017 July-September Pennsylvania 1500 6000 18500 18500 8 1600 9
2017 July-September South Carolina 1700 640 14500 14500 12 440 3
2017 July-September South Dakota 16500 6000 152000 159000 10 7500 5
2017 July-September Tennessee 1700 800 10000 10000 17 960 10
2017 July-September Texas 15000 21000 104000 115000 13 7500 7
2017 July-September Utah 6500 5500 35000 35000 19 3200 9
2017 July-September Vermont 180 520 7500 7500 2 270 4
2017 July-September Virginia 1200 430 11500 11500 10 430 4
2017 July-September Washington 17000 5500 82000 92000 18 10500 11
2017 July-September West Virginia 930 440 9000 9000 10 1900 21
2017 July-September Wisconsin 12500 6000 74000 75000 17 9000 12
2017 July-September Wyoming 5500 3100 35000 36000 15 3500 10
2017 July-September Other States 1070 380 8100 10000 11 650 7
2017 July-September United States 394810 284370 2994500 NA 13 449550 15
2017 October-December Alabama 990 550 7500 7500 13 500 7
2017 October-December Arizona 6500 1300 27000 30000 22 1100 4
2017 October-December Arkansas 7500 2500 25000 25000 30 440 2
2017 October-December California 155000 90000 680000 1200000 13 104000 9
2017 October-December Colorado 7000 1500 34000 34000 21 4000 12
2017 October-December Connecticut 330 190 4000 4000 8 110 3
2017 October-December Florida 50000 55000 180000 240000 21 36000 15
2017 October-December Georgia 21000 4300 125000 145000 14 2200 2
2017 October-December Hawaii 130 970 15000 15000 1 290 2
2017 October-December Idaho 9000 10000 113000 164000 5 5000 3
2017 October-December Illinois 1800 140 13500 13500 13 460 3
2017 October-December Indiana 1700 320 11500 11500 15 100 1
2017 October-December Iowa 6500 250 45000 45000 14 3400 8
2017 October-December Kansas 830 140 6500 6500 13 40 1
2017 October-December Kentucky 870 50 7500 7500 12 120 2
2017 October-December Louisiana 2700 390 58000 60000 5 1900 3
2017 October-December Maine 60 220 5500 6000 1 110 2
2017 October-December Maryland 1300 20 8000 10500 12 410 4
2017 October-December Massachusetts 1100 120 6000 6000 18 550 9
2017 October-December Michigan 11500 990 88000 88000 13 1900 2
2017 October-December Minnesota 7000 1900 98000 98000 7 450 NA
2017 October-December Mississippi 3400 280 14000 22000 15 830 4
2017 October-December Missouri 820 100 9500 9500 9 230 2
2017 October-December Montana 13000 5500 115000 121000 11 2900 2
2017 October-December Nebraska 7500 80 42000 42000 18 50 NA
2017 October-December New Jersey 1200 330 15500 15500 8 270 2
2017 October-December New Mexico 1900 1700 8000 8000 24 NA NA
2017 October-December New York 3900 820 51000 51000 8 460 1
2017 October-December North Carolina 5000 60 23000 23000 22 290 1
2017 October-December North Dakota 26000 10000 410000 410000 6 2900 1
2017 October-December Ohio 2800 510 18500 18500 15 960 5
2017 October-December Oklahoma 100 40 3700 46000 NA NA NA
2017 October-December Oregon 10000 70 94000 94000 11 18500 20
2017 October-December Pennsylvania 5500 2500 24000 24000 23 1100 5
2017 October-December South Carolina 2000 1300 12500 15000 13 750 5
2017 October-December South Dakota 6500 NA 111000 111000 6 NA NA
2017 October-December Tennessee 1300 230 8500 10500 12 320 3
2017 October-December Texas 20000 3200 127000 285000 7 1900 1
2017 October-December Utah 2000 480 29000 29000 7 70 NA
2017 October-December Vermont 470 10 6500 6500 7 10 NA
2017 October-December Virginia 1100 300 9500 9500 12 210 2
2017 October-December Washington 4000 2900 66000 72000 6 14000 19
2017 October-December West Virginia 1200 70 8500 8500 14 1600 19
2017 October-December Wisconsin 8500 530 51000 55000 15 3000 5
2017 October-December Wyoming 3500 2500 28000 29000 12 320 1
2017 October-December Other States 360 150 6070 6970 5 240 3
2017 October-December United States 424860 204510 2849770 NA 15 213990 8
2018 January-March Alabama 820 1200 7500 7500 11 1500 20
2018 January-March Arizona 6000 810 25000 26000 23 230 1
2018 January-March Arkansas 7500 540 22000 22000 34 810 4
2018 January-March California 220000 200000 1150000 1540000 14 132500 9
2018 January-March Colorado 4900 1400 13000 21000 23 190 1
2018 January-March Connecticut 140 220 2900 2900 5 330 11
2018 January-March Florida 35000 57000 245000 255000 14 38000 15
2018 January-March Georgia 25000 29000 134000 139000 18 39000 28
2018 January-March Hawaii 1600 1200 15000 15000 11 5100 34
2018 January-March Idaho 22000 2500 164000 168000 13 2600 2
2018 January-March Illinois 2400 1000 10500 10500 23 630 6
2018 January-March Indiana 1000 300 7000 8000 13 30 NA
2018 January-March Iowa 1300 420 41000 45000 3 110 NA
2018 January-March Kansas 950 500 3700 3700 26 410 11
2018 January-March Kentucky 1600 520 5500 5500 29 20 NA
2018 January-March Louisiana 3600 4100 50000 52000 7 320 1
2018 January-March Maine 240 40 1900 1900 13 30 2
2018 January-March Maryland 1500 NA 8000 8000 19 190 2
2018 January-March Massachusetts 1000 240 3800 3800 26 290 8
2018 January-March Michigan 8000 10500 16500 34000 24 3900 11
2018 January-March Minnesota 3900 13500 39000 62000 6 2900 5
2018 January-March Mississippi 2000 28000 19000 32000 6 5500 17
2018 January-March Missouri 1400 1400 8000 8000 18 50 1
2018 January-March Montana 140 840 35000 60000 NA NA NA
2018 January-March Nebraska 430 NA 6500 14000 3 NA NA
2018 January-March New Jersey 730 180 6500 6500 11 190 3
2018 January-March New Mexico 3900 180 7500 7500 52 NA NA
2018 January-March New York 3700 400 26000 26000 14 170 1
2018 January-March North Carolina 4200 2400 18500 18500 23 260 1
2018 January-March North Dakota 3200 2600 64000 99000 3 10 NA
2018 January-March Ohio 4000 300 12000 14000 29 580 4
2018 January-March Oklahoma 3700 890 17000 18000 21 240 1
2018 January-March Oregon 4100 17000 81000 89000 5 3900 4
2018 January-March Pennsylvania 1500 1600 14500 14500 10 670 5
2018 January-March South Carolina 1800 1900 13500 14500 12 2800 19
2018 January-March South Dakota 390 250 23000 29000 1 90 NA
2018 January-March Tennessee 3000 600 10000 10000 30 470 5
2018 January-March Texas 22000 118000 205000 290000 8 42000 14
2018 January-March Utah 620 490 7500 17000 4 50 NA
2018 January-March Vermont 570 20 5500 5500 10 NA NA
2018 January-March Virginia 2100 540 7000 7000 30 160 2
2018 January-March Washington 4600 7000 44000 89000 5 860 1
2018 January-March West Virginia 2000 330 4700 8500 24 60 1
2018 January-March Wisconsin 4600 2800 21000 29000 16 1560 5
2018 January-March Wyoming 220 70 5500 8000 3 NA NA
2018 January-March Other States 1870 160 3720 6520 29 40 1
2018 January-March United States 425220 512940 2631220 NA 16 288750 11
2018 April-June Alabama 810 1300 7500 8500 10 710 8
2018 April-June Arizona 2600 12000 18500 19500 13 2100 11
2018 April-June Arkansas 1500 14000 11500 11500 13 1900 17
2018 April-June California 70000 176000 1140000 1190000 6 254000 21
2018 April-June Colorado 2300 9500 16500 26000 9 4570 18
2018 April-June Connecticut 120 340 3600 3600 3 170 5
2018 April-June Florida 48000 54000 270000 280000 17 69000 25
2018 April-June Georgia 16000 34000 134000 134000 12 16000 12
2018 April-June Hawaii 280 300 14500 14500 2 3100 21
2018 April-June Idaho 4800 17000 60000 95000 5 29000 31
2018 April-June Illinois 2100 4700 10000 10500 20 2800 27
2018 April-June Indiana 1800 4000 8000 9000 20 730 8
2018 April-June Iowa 4300 15500 45000 47000 9 4800 10
2018 April-June Kansas 170 1800 3900 3900 4 2100 54
2018 April-June Kentucky 450 1400 4800 6000 8 560 9
2018 April-June Louisiana 970 7000 48000 48000 2 4000 8
2018 April-June Maine 1100 430 2200 17000 6 880 5
2018 April-June Maryland 370 2400 7000 8000 5 1200 15
2018 April-June Massachusetts 260 910 3600 7500 3 350 5
2018 April-June Michigan 6000 18000 36000 69000 9 8000 12
2018 April-June Minnesota 6500 46000 69000 108000 6 24000 22
2018 April-June Mississippi 5000 3900 53000 54000 9 6500 12
2018 April-June Missouri 390 1800 7000 7000 6 800 11
2018 April-June Montana 4800 26000 50000 171000 3 20000 12
2018 April-June Nebraska 2700 3100 10500 40000 7 700 2
2018 April-June New Jersey 270 1200 4400 15000 2 170 1
2018 April-June New Mexico 50 290 1900 4300 1 450 10
2018 April-June New York 3300 8000 20000 36000 9 2300 6
2018 April-June North Carolina 1200 3600 16000 17500 7 800 5
2018 April-June North Dakota 11000 30000 72000 430000 3 46000 11
2018 April-June Ohio 1100 9000 11000 13000 8 1800 14
2018 April-June Oklahoma 1600 9000 15500 15500 10 6500 42
2018 April-June Oregon 3400 23000 41000 106000 3 24000 23
2018 April-June Pennsylvania 1100 6000 15500 19500 6 1600 8
2018 April-June South Carolina 1300 2400 14000 14000 9 4000 29
2018 April-June South Dakota 12000 21000 10500 161000 7 65000 40
2018 April-June Tennessee 1200 3200 8000 8000 15 1300 16
2018 April-June Texas 31000 100000 305000 310000 10 69000 22
2018 April-June Utah 1700 10000 14500 26000 7 4100 16
2018 April-June Vermont 520 2600 5500 6500 8 140 2
2018 April-June Virginia 490 2400 5000 5500 9 700 13
2018 April-June Washington 6500 19000 55000 122000 5 18900 15
2018 April-June West Virginia 490 2100 7000 7000 7 550 8
2018 April-June Wisconsin 6000 12500 24000 50000 12 6600 13
2018 April-June Wyoming 2200 3100 8500 22000 10 2300 10
2018 April-June Other States 260 1880 4260 7660 3 930 12
2018 April-June United States 270000 725650 2692660 NA 10 715110 27
2018 July-September Alabama 1700 1600 8500 8500 20 1300 15
2018 July-September Arizona 8000 3200 31000 31000 26 3100 10
2018 July-September Arkansas 2300 2600 29000 29000 8 840 3
2018 July-September California 73000 63000 590000 700000 10 141000 20
2018 July-September Colorado 5000 1500 34000 35000 14 5000 14
2018 July-September Connecticut 130 80 3200 3200 4 310 10
2018 July-September Florida 30000 53000 197000 220000 14 40000 18
2018 July-September Georgia 17000 27000 134000 138000 12 33000 24
2018 July-September Hawaii 1800 1700 16500 16500 11 3000 18
2018 July-September Idaho 14000 15000 82000 101000 14 21000 21
2018 July-September Illinois 660 700 11000 11000 6 420 4
2018 July-September Indiana 990 520 11500 11500 9 1200 10
2018 July-September Iowa 3600 1200 56000 57000 6 990 2
2018 July-September Kansas 950 300 6000 6000 16 180 3
2018 July-September Kentucky 840 300 6500 7000 12 660 9
2018 July-September Louisiana 1900 1600 53000 53000 4 2300 4
2018 July-September Maine 890 60 12500 12500 7 170 1
2018 July-September Maryland 360 580 7500 7500 5 680 9
2018 July-September Massachusetts 2200 850 8000 10000 22 730 7
2018 July-September Michigan 8000 3000 88000 88000 9 22000 25
2018 July-September Minnesota 29000 1600 121000 127000 23 6500 5
2018 July-September Mississippi 2900 110 16500 16500 18 650 4
2018 July-September Missouri 540 260 10000 10000 5 410 4
2018 July-September Montana 18500 3100 145000 153000 12 22000 14
2018 July-September Nebraska 6500 8500 52000 54000 12 5000 9
2018 July-September New Jersey 320 250 14000 14000 2 220 2
2018 July-September New Mexico 1200 3800 6000 7000 17 1000 14
2018 July-September New York 3900 3600 55000 56000 7 3700 7
2018 July-September North Carolina 2200 2600 18000 18000 12 2000 11
2018 July-September North Dakota 59000 23000 455000 490000 12 14500 3
2018 July-September Ohio 1300 1300 16000 16000 8 2100 13
2018 July-September Oklahoma 370 20 2100 2100 18 10 NA
2018 July-September Oregon 13000 3000 116000 117000 11 49000 42
2018 July-September Pennsylvania 860 2900 20000 21000 4 2300 11
2018 July-September South Carolina 1400 670 9500 11500 12 1100 10
2018 July-September South Dakota 22000 8000 168000 197000 11 6500 3
2018 July-September Tennessee 900 540 9000 9000 10 1000 11
2018 July-September Texas 7500 7500 112000 124000 6 9500 8
2018 July-September Utah 4400 970 30000 30000 15 1400 5
2018 July-September Vermont 90 1200 7000 7000 1 80 1
2018 July-September Virginia 610 1000 7500 7500 8 990 13
2018 July-September Washington 12000 7000 76000 84000 14 3600 4
2018 July-September West Virginia 520 170 7500 8000 7 1200 15
2018 July-September Wisconsin 10000 2400 61000 69000 14 3800 6
2018 July-September Wyoming 3900 1800 33000 34000 11 3900 11
2018 July-September Other States 890 480 6490 9990 9 440 4
2018 July-September United States 377120 263560 2958790 NA 13 420780 14
2018 October-December Alabama 830 210 6500 6500 13 1300 20
2018 October-December Arizona 5000 2200 26000 27000 19 330 1
2018 October-December Arkansas 6000 110 30000 31000 19 230 1
2018 October-December California 170000 86000 680000 1200000 14 46000 4
2018 October-December Colorado 3500 370 30000 30000 12 10 NA
2018 October-December Connecticut 220 NA 3500 3500 6 60 2
2018 October-December Florida 43000 53000 240000 290000 15 20000 7
2018 October-December Georgia 19500 6500 148000 164000 12 49000 30
2018 October-December Hawaii 940 1700 16000 16000 6 6000 38
2018 October-December Idaho 15000 9000 99000 159000 9 910 1
2018 October-December Illinois 1400 600 12000 12000 12 350 3
2018 October-December Indiana 3300 40 9000 9000 37 1200 13
2018 October-December Iowa 4200 630 21000 21000 20 80 NA
2018 October-December Kansas 1000 420 5500 5500 18 10 NA
2018 October-December Kentucky 2000 60 7000 7000 29 430 6
2018 October-December Louisiana 2600 130 50000 52000 5 200 NA
2018 October-December Maine 1400 210 12000 12000 12 880 7
2018 October-December Maryland 690 60 7000 9000 8 90 1
2018 October-December Massachusetts 650 110 4900 4900 13 320 7
2018 October-December Michigan 6000 3900 77000 77000 8 1800 2
2018 October-December Minnesota 11500 2500 84000 86000 13 590 1
2018 October-December Mississippi 2000 330 14500 25000 8 50 NA
2018 October-December Missouri 880 170 10000 10000 9 150 2
2018 October-December Montana 5500 3100 98000 102000 5 500 NA
2018 October-December Nebraska 5000 7000 45000 45000 11 840 2
2018 October-December New Jersey 1300 30 15500 15500 8 80 1
2018 October-December New Mexico 3000 50 8000 8000 38 NA NA
2018 October-December New York 4400 1000 53000 53000 8 1500 3
2018 October-December North Carolina 2700 250 16000 16000 17 300 2
2018 October-December North Dakota 29000 7500 430000 435000 7 1500 NA
2018 October-December Ohio 2100 170 15500 15500 14 450 3
2018 October-December Oklahoma 2500 60 2200 57000 4 20 NA
2018 October-December Oregon 13000 10500 89000 101000 13 12000 12
2018 October-December Pennsylvania 4000 270 21000 21000 19 1500 7
2018 October-December South Carolina 1500 770 10000 12500 12 790 6
2018 October-December South Dakota 21000 2000 140000 140000 15 430 NA
2018 October-December Tennessee 1900 30 8000 8500 22 370 4
2018 October-December Texas 17000 11000 116000 260000 7 70 NA
2018 October-December Utah 3400 180 27000 27000 13 400 1
2018 October-December Vermont 170 10 6500 6500 3 20 NA
2018 October-December Virginia 1100 80 7000 7000 16 1300 19
2018 October-December Washington 11000 5500 75000 81000 14 1400 2
2018 October-December West Virginia 1200 50 7000 7000 17 70 1
2018 October-December Wisconsin 8500 1600 48000 48000 18 530 1
2018 October-December Wyoming 2700 220 30000 32000 8 NA NA
2018 October-December Other States 1150 20 8370 8670 13 500 6
2018 October-December United States 444730 219640 2868970 NA 16 154560 5
2019 January-March Alabama 650 800 5500 5500 12 200 4
2019 January-March Arizona 2500 430 22000 22000 11 90 NA
2019 January-March Arkansas 6500 20 28000 28000 23 20 NA
2019 January-March California 235000 83000 1140000 1580000 15 86000 5
2019 January-March Colorado 320 NA 5000 7500 4 NA NA
2019 January-March Connecticut 270 170 3100 3100 9 10 NA
2019 January-March Florida 46000 41000 300000 315000 15 16500 5
2019 January-March Georgia 14500 19500 120000 129000 11 8000 6
2019 January-March Hawaii 390 660 16500 16500 2 3700 22
2019 January-March Idaho 12500 4600 132000 145000 9 1100 1
2019 January-March Illinois 2300 210 9000 9000 26 80 1
2019 January-March Indiana 710 440 6000 6000 12 280 5
2019 January-March Iowa 1600 170 7500 11500 14 140 1
2019 January-March Kansas 1500 370 4500 4500 33 110 2
2019 January-March Kentucky 890 60 3700 4400 20 30 1
2019 January-March Louisiana 3500 9000 49000 51000 7 16000 31
2019 January-March Maine 470 10 7000 7000 7 30 NA
2019 January-March Maryland 2300 30 8000 8000 29 10 NA
2019 January-March Massachusetts 680 60 3800 3800 18 20 1
2019 January-March Michigan 6500 NA 24000 33000 20 NA NA
2019 January-March Minnesota 2200 80 17000 43000 5 470 1
2019 January-March Mississippi 2400 3800 26000 29000 8 1700 6
2019 January-March Missouri 1100 80 8500 8500 13 60 1
2019 January-March Montana 3500 1700 37000 68000 5 1900 3
2019 January-March Nebraska 2500 NA 13500 16500 15 NA NA
2019 January-March New Jersey 310 130 6000 6000 5 60 1
2019 January-March New Mexico 170 NA 4800 4800 4 NA NA
2019 January-March New York 3400 110 24000 24000 14 80 NA
2019 January-March North Carolina 1700 750 10500 14500 12 890 6
2019 January-March North Dakota 1100 NA 92000 102000 1 1300 1
2019 January-March Ohio 3500 1700 10500 12500 28 440 4
2019 January-March Oklahoma 50 20 21000 55000 NA NA NA
2019 January-March Oregon 7500 8000 89000 95000 8 1800 2
2019 January-March Pennsylvania 2900 370 15000 15000 19 320 2
2019 January-March South Carolina 690 2000 12000 13000 5 340 3
2019 January-March South Dakota 1100 NA 18500 18500 6 NA NA
2019 January-March Tennessee 1500 240 6000 7000 21 320 5
2019 January-March Texas 17000 61000 260000 330000 5 35000 11
2019 January-March Utah 1800 900 8500 11000 16 NA NA
2019 January-March Vermont 260 50 6500 6500 4 NA NA
2019 January-March Virginia 1100 80 5500 5500 20 110 2
2019 January-March Washington 7000 5500 51000 75000 9 2200 3
2019 January-March West Virginia 1300 20 5000 7000 19 60 1
2019 January-March Wisconsin 3700 580 16500 17000 22 100 1
2019 January-March Wyoming 250 NA 6500 9500 3 NA NA
2019 January-March Other States 590 70 6070 6070 10 30 NA
2019 January-March United States 407700 247710 2671470 NA 15 179500 7
2019 April-June Alabama NA NA NA NA NA NA NA
2019 April-June Arizona NA NA NA NA NA NA NA
2019 April-June Arkansas NA NA NA NA NA NA NA
2019 April-June California NA NA NA NA NA NA NA
2019 April-June Colorado NA NA NA NA NA NA NA
2019 April-June Connecticut NA NA NA NA NA NA NA
2019 April-June Florida NA NA NA NA NA NA NA
2019 April-June Georgia NA NA NA NA NA NA NA
2019 April-June Hawaii NA NA NA NA NA NA NA
2019 April-June Idaho NA NA NA NA NA NA NA
2019 April-June Illinois NA NA NA NA NA NA NA
2019 April-June Indiana NA NA NA NA NA NA NA
2019 April-June Iowa NA NA NA NA NA NA NA
2019 April-June Kansas NA NA NA NA NA NA NA
2019 April-June Kentucky NA NA NA NA NA NA NA
2019 April-June Louisiana NA NA NA NA NA NA NA
2019 April-June Maine NA NA NA NA NA NA NA
2019 April-June Maryland NA NA NA NA NA NA NA
2019 April-June Massachusetts NA NA NA NA NA NA NA
2019 April-June Michigan NA NA NA NA NA NA NA
2019 April-June Minnesota NA NA NA NA NA NA NA
2019 April-June Mississippi NA NA NA NA NA NA NA
2019 April-June Missouri NA NA NA NA NA NA NA
2019 April-June Montana NA NA NA NA NA NA NA
2019 April-June Nebraska NA NA NA NA NA NA NA
2019 April-June New Jersey NA NA NA NA NA NA NA
2019 April-June New Mexico NA NA NA NA NA NA NA
2019 April-June New York NA NA NA NA NA NA NA
2019 April-June North Carolina NA NA NA NA NA NA NA
2019 April-June North Dakota NA NA NA NA NA NA NA
2019 April-June Ohio NA NA NA NA NA NA NA
2019 April-June Oklahoma NA NA NA NA NA NA NA
2019 April-June Oregon NA NA NA NA NA NA NA
2019 April-June Pennsylvania NA NA NA NA NA NA NA
2019 April-June South Carolina NA NA NA NA NA NA NA
2019 April-June South Dakota NA NA NA NA NA NA NA
2019 April-June Tennessee NA NA NA NA NA NA NA
2019 April-June Texas NA NA NA NA NA NA NA
2019 April-June Utah NA NA NA NA NA NA NA
2019 April-June Vermont NA NA NA NA NA NA NA
2019 April-June Virginia NA NA NA NA NA NA NA
2019 April-June Washington NA NA NA NA NA NA NA
2019 April-June West Virginia NA NA NA NA NA NA NA
2019 April-June Wisconsin NA NA NA NA NA NA NA
2019 April-June Wyoming NA NA NA NA NA NA NA
2019 April-June Other States NA NA NA NA NA NA NA
2019 April-June United States NA NA NA NA NA NA NA
2019 July-September Alabama 990 160 7000 7000 14 330 5
2019 July-September Arizona 2000 5500 26000 30000 7 3800 13
2019 July-September Arkansas 2100 170 20000 21000 10 680 3
2019 July-September California 93000 87000 650000 700000 13 108000 15
2019 July-September Colorado 9500 2200 33000 36000 26 3400 9
2019 July-September Connecticut 200 70 4400 4400 5 470 11
2019 July-September Florida 20000 46000 210000 240000 8 33000 14
2019 July-September Georgia 13000 12000 116000 118000 11 36000 31
2019 July-September Hawaii 200 200 17000 17000 1 6000 35
2019 July-September Idaho 10500 8500 95000 111000 9 12500 11
2019 July-September Illinois 940 460 13500 13500 7 1300 10
2019 July-September Indiana 1000 2200 14000 16000 6 1500 9
2019 July-September Iowa 3400 2000 30000 33000 10 4800 15
2019 July-September Kansas 1900 190 7500 7500 25 400 5
2019 July-September Kentucky 850 700 8000 8500 10 430 5
2019 July-September Louisiana 4100 4400 42000 44000 9 13000 30
2019 July-September Maine 1100 460 11500 12000 9 3500 29
2019 July-September Maryland 790 720 7500 7500 11 1200 16
2019 July-September Massachusetts 1100 800 13500 13500 8 560 4
2019 July-September Michigan 11000 3000 94000 99000 11 3300 3
2019 July-September Minnesota 21000 5000 126000 129000 16 2100 2
2019 July-September Mississippi 2900 550 23000 23000 13 850 4
2019 July-September Missouri 500 260 10500 10500 5 350 3
2019 July-September Montana 18500 3600 147000 154000 12 12500 8
2019 July-September Nebraska 3700 680 40000 41000 9 1400 3
2019 July-September New Jersey 680 650 16000 16000 4 3100 19
2019 July-September New Mexico 170 1000 2400 5500 3 550 10
2019 July-September New York 8500 3200 65000 69000 12 3700 5
2019 July-September North Carolina 2700 1800 22000 22000 12 5000 23
2019 July-September North Dakota 81000 15000 530000 530000 15 17500 3
2019 July-September Ohio 1600 2800 19500 19500 8 3000 15
2019 July-September Oklahoma 930 130 7500 7500 12 1100 15
2019 July-September Oregon 8000 6000 83000 118000 7 21000 18
2019 July-September Pennsylvania 980 1800 19000 20000 5 1900 10
2019 July-September South Carolina 2200 2000 14500 14500 15 1400 10
2019 July-September South Dakota 51000 1300 255000 255000 20 8000 3
2019 July-September Tennessee 4500 2200 14000 14000 32 2200 16
2019 July-September Texas 11000 6500 126000 133000 8 7000 5
2019 July-September Utah 2800 3500 24000 29000 10 1700 6
2019 July-September Vermont 120 80 7000 7000 2 490 7
2019 July-September Virginia 570 350 9000 9000 6 820 9
2019 July-September Washington 21000 12000 85000 97000 22 10000 10
2019 July-September West Virginia 1100 200 10000 10000 11 1100 11
2019 July-September Wisconsin 6500 2400 63000 63000 10 10000 16
2019 July-September Wyoming 3000 2500 24000 27000 11 3500 13
2019 July-September Other States 2080 320 13660 13900 15 900 6
2019 July-September United States 434700 252550 3175960 NA 14 355330 11
2019 October-December Alabama 660 240 6000 6000 11 70 1
2019 October-December Arizona 7000 300 34000 36000 19 300 1
2019 October-December Arkansas 1600 430 19000 19500 8 310 2
2019 October-December California 136000 160000 700000 1300000 10 37000 3
2019 October-December Colorado 8000 1100 27000 27000 30 440 2
2019 October-December Connecticut 300 10 3800 4000 8 50 1
2019 October-December Florida 30000 28000 270000 300000 10 15000 5
2019 October-December Georgia 20000 10500 119000 131000 15 10500 8
2019 October-December Hawaii 1300 300 17000 17000 8 50 NA
2019 October-December Idaho 15500 1800 111000 196000 8 1000 1
2019 October-December Illinois 1700 1000 13000 13000 13 1500 12
2019 October-December Indiana 1300 160 17500 17500 7 180 1
2019 October-December Iowa 7500 1500 32000 32000 23 530 2
2019 October-December Kansas 650 190 4800 4900 13 460 9
2019 October-December Kentucky 410 190 8500 8500 5 170 2
2019 October-December Louisiana 2300 70 41000 46000 5 80 NA
2019 October-December Maine 770 110 11500 11500 7 40 NA
2019 October-December Maryland 1100 390 6500 8000 14 420 5
2019 October-December Massachusetts 1200 60 5000 5000 24 130 3
2019 October-December Michigan 6500 820 84000 84000 8 1500 2
2019 October-December Minnesota 15500 3400 97000 97000 16 60 NA
2019 October-December Mississippi 3400 350 21000 29000 12 50 NA
2019 October-December Missouri 1500 260 9000 10000 15 10 NA
2019 October-December Montana 7000 770 71000 79000 9 4000 5
2019 October-December Nebraska 2700 320 37000 38000 7 10 NA
2019 October-December New Jersey 220 60 15500 15500 1 80 1
2019 October-December New Mexico 70 30 6000 6000 1 10 NA
2019 October-December New York 10000 630 65000 65000 15 510 1
2019 October-December North Carolina 3200 240 17500 18000 18 770 4
2019 October-December North Dakota 27000 3000 420000 420000 6 4300 1
2019 October-December Ohio 2700 800 19000 19000 14 390 2
2019 October-December Oklahoma 2500 460 6500 37000 7 NA NA
2019 October-December Oregon 15000 650 115000 130000 12 2000 2
2019 October-December Pennsylvania 3800 1600 21000 21000 18 1100 5
2019 October-December South Carolina 1900 1400 12500 13500 14 430 3
2019 October-December South Dakota 7500 NA 189000 189000 4 40 NA
2019 October-December Tennessee 1300 20 11000 11000 12 70 1
2019 October-December Texas 17500 8000 129000 240000 7 1700 1
2019 October-December Utah 4400 970 30000 32000 14 90 NA
2019 October-December Vermont 190 100 7000 7000 3 270 4
2019 October-December Virginia 1200 10 8000 8000 15 190 2
2019 October-December Washington 12500 810 89000 93000 13 100 NA
2019 October-December West Virginia 1500 30 7500 8000 19 1600 20
2019 October-December Wisconsin 8500 1800 46000 46000 18 3000 7
2019 October-December Wyoming 3300 100 27000 28000 12 490 2
2019 October-December Other States 1340 280 11010 11510 12 NA NA
2019 October-December United States 399510 233260 3018110 NA 13 91000 3
2020 January-March Alabama 410 1000 5500 8000 5 780 10
2020 January-March Arizona 6500 150 29000 32000 20 120 NA
2020 January-March Arkansas 1200 700 16500 17500 7 30 NA
2020 January-March California 230000 240000 1350000 1710000 13 66000 4
2020 January-March Colorado 650 850 4500 16000 4 500 3
2020 January-March Connecticut 330 60 3700 4100 8 NA NA
2020 January-March Florida 30000 41000 295000 310000 10 8000 3
2020 January-March Georgia 14500 32000 115000 121000 12 22000 18
2020 January-March Hawaii 1500 1000 16000 16000 9 2200 14
2020 January-March Idaho 18500 4400 156000 168000 11 920 1
2020 January-March Illinois 2100 900 11500 13000 16 160 1
2020 January-March Indiana 1600 880 11000 11500 14 420 4
2020 January-March Iowa 1600 1200 9000 21000 8 420 2
2020 January-March Kansas 750 1200 4500 7000 11 130 2
2020 January-March Kentucky 1200 1500 7000 10500 11 120 1
2020 January-March Louisiana 4800 9000 44000 48000 10 20000 42
2020 January-March Maine 130 NA 1300 1700 8 NA NA
2020 January-March Maryland 640 NA 7000 7500 9 30 NA
2020 January-March Massachusetts 350 600 3800 4000 9 100 3
2020 January-March Michigan 6000 3800 60000 65000 9 100 NA
2020 January-March Minnesota 1000 2000 21000 57000 2 40 NA
2020 January-March Mississippi 5000 16000 26000 28000 18 660 2
2020 January-March Missouri 2100 30 8500 8500 25 NA NA
2020 January-March Montana 150 NA 18000 48000 NA NA NA
2020 January-March Nebraska 670 70 9000 17000 4 NA NA
2020 January-March New Jersey 250 110 6500 7000 4 40 1
2020 January-March New Mexico 40 120 6000 6000 1 NA NA
2020 January-March New York 3700 230 29000 36000 10 370 1
2020 January-March North Carolina 2200 3000 15000 23000 10 490 2
2020 January-March North Dakota 4500 2500 53000 82000 5 NA NA
2020 January-March Ohio 5500 840 15500 20000 28 1100 6
2020 January-March Oklahoma 700 5000 19500 19500 4 NA NA
2020 January-March Oregon 4800 9000 97000 108000 4 1700 2
2020 January-March Pennsylvania 1000 1100 18500 24000 4 320 1
2020 January-March South Carolina 800 3500 13000 16500 5 1100 7
2020 January-March South Dakota 1200 20 20000 20000 6 NA NA
2020 January-March Tennessee 1500 1000 8000 14000 11 130 1
2020 January-March Texas 35000 83000 235000 340000 10 24000 7
2020 January-March Utah 400 4200 12000 17000 2 NA NA
2020 January-March Vermont 520 NA 6500 7500 7 70 1
2020 January-March Virginia 1100 1600 6000 7000 16 60 1
2020 January-March Washington 1500 580 49000 74000 2 150 NA
2020 January-March West Virginia 1100 450 6000 8000 14 680 9
2020 January-March Wisconsin 1500 2000 16000 26000 6 370 1
2020 January-March Wyoming 140 450 4000 17000 1 60 NA
2020 January-March Other States 440 160 7800 8200 5 20 NA
2020 January-March United States 399570 477200 2876100 NA 14 153390 5
2020 April-June Alabama 4100 4700 8500 8500 48 2620 31
2020 April-June Arizona 1300 14000 26000 26000 5 4700 18
2020 April-June Arkansas 1900 5000 17000 17000 11 800 5
2020 April-June California 74000 184000 1200000 1200000 6 240000 20
2020 April-June Colorado 2100 6000 16500 27000 8 2800 10
2020 April-June Connecticut 30 1200 3900 4300 1 480 11
2020 April-June Florida 39000 36000 325000 325000 12 23000 7
2020 April-June Georgia 10000 19500 141000 143000 7 19000 13
2020 April-June Hawaii 40 240 15500 15500 NA 2300 15
2020 April-June Idaho 14500 32000 48000 81000 18 29000 36
2020 April-June Illinois 1500 4200 12000 12000 13 1700 14
2020 April-June Indiana 920 4300 11000 12000 8 3200 27
2020 April-June Iowa 3600 14500 21000 29000 12 4700 16
2020 April-June Kansas 440 1800 7500 8000 6 1800 23
2020 April-June Kentucky 1200 4200 11000 11000 11 3500 32
2020 April-June Louisiana 1800 2200 53000 53000 3 4700 9
2020 April-June Maine 1300 520 1600 22000 6 110 1
2020 April-June Maryland 680 4500 7000 8000 9 1700 21
2020 April-June Massachusetts 740 980 4300 13500 5 590 4
2020 April-June Michigan 2600 9500 64000 79000 3 10000 13
2020 April-June Minnesota 6500 20000 59000 126000 5 2600 2
2020 April-June Mississippi 3000 3700 34000 37000 8 570 2
2020 April-June Missouri 390 2900 6500 6500 6 1200 18
2020 April-June Montana 3800 14000 48000 120000 3 16500 14
2020 April-June Nebraska 1800 7000 16500 39000 5 1100 3
2020 April-June New Jersey 760 1600 7000 20000 4 720 4
2020 April-June New Mexico 50 250 3100 6000 1 60 1
2020 April-June New York 4900 6500 33000 56000 9 3300 6
2020 April-June North Carolina 1600 6000 24000 25000 6 1300 5
2020 April-June North Dakota 17500 29000 67000 395000 4 37000 9
2020 April-June Ohio 1700 9500 15500 16500 10 3700 22
2020 April-June Oklahoma 1500 6000 16000 16000 9 3100 19
2020 April-June Oregon 2500 10500 89000 95000 3 19000 20
2020 April-June Pennsylvania 1000 6000 24000 27000 4 1700 6
2020 April-June South Carolina 1700 2700 19500 20000 9 2500 13
2020 April-June South Dakota 4600 8500 9500 205000 2 14500 7
2020 April-June Tennessee 1200 4200 13500 13500 9 3200 24
2020 April-June Texas 25000 75000 360000 385000 6 136000 35
2020 April-June Utah 2700 7000 21000 31000 9 13500 44
2020 April-June Vermont 260 700 7000 7000 4 130 2
2020 April-June Virginia 1200 4800 7500 8000 15 1300 16
2020 April-June Washington 3100 5000 50000 114000 3 3300 3
2020 April-June West Virginia 570 1600 7500 7500 8 1500 20
2020 April-June Wisconsin 1700 11500 27000 53000 3 4600 9
2020 April-June Wyoming 1600 2300 17500 24000 7 2100 9
2020 April-June Other States 250 1270 6500 7440 3 1500 20
2020 April-June United States 252630 596860 2982900 NA 8 632680 21
2020 July-September Alabama 3700 1800 9000 19000 19 990 5
2020 July-September Arizona 8000 2600 28000 30000 27 1800 6
2020 July-September Arkansas 1700 1500 19000 22000 8 390 2
2020 July-September California 69000 61000 640000 700000 10 108000 15
2020 July-September Colorado 7000 3800 29000 29000 24 5500 19
2020 July-September Connecticut 300 130 4700 4700 6 150 3
2020 July-September Florida 29000 36000 220000 230000 13 31000 13
2020 July-September Georgia 23000 22000 150000 163000 14 35000 21
2020 July-September Hawaii 500 4000 18500 18500 3 3400 18
2020 July-September Idaho 11000 18500 70000 85000 13 8500 10
2020 July-September Illinois 1400 770 14000 14000 10 690 5
2020 July-September Indiana 1600 1200 15000 15000 11 2700 18
2020 July-September Iowa 1800 1100 34000 38000 5 2900 8
2020 July-September Kansas 910 600 7000 7000 13 730 10
2020 July-September Kentucky 1400 800 11500 12000 12 510 4
2020 July-September Louisiana 2600 1200 48000 48000 5 3100 6
2020 July-September Maine 1500 700 9500 10000 15 820 8
2020 July-September Maryland 690 1200 7500 7500 9 220 3
2020 July-September Massachusetts 330 840 11000 11000 3 810 7
2020 July-September Michigan 34000 37000 96000 106000 32 11000 10
2020 July-September Minnesota 10500 1800 114000 119000 9 3700 3
2020 July-September Mississippi 1600 2500 26000 29000 6 130 NA
2020 July-September Missouri 730 290 8000 8000 9 820 10
2020 July-September Montana 8500 6500 138000 139000 6 28000 20
2020 July-September Nebraska 4300 3000 47000 48000 9 3100 6
2020 July-September New Jersey 2300 1500 17500 18500 12 1800 10
2020 July-September New Mexico 1600 3300 5500 5500 29 760 14
2020 July-September New York 3600 5500 61000 61000 6 1600 3
2020 July-September North Carolina 4600 950 26000 27000 17 5500 20
2020 July-September North Dakota 53000 57000 455000 495000 11 33000 7
2020 July-September Ohio 1900 730 22000 22000 9 2100 10
2020 July-September Oklahoma 1100 150 7000 8000 14 930 12
2020 July-September Oregon 12000 13000 102000 124000 10 28000 23
2020 July-September Pennsylvania 2200 2500 27000 27000 8 1200 4
2020 July-September South Carolina 1800 1200 12000 13500 13 2200 16
2020 July-September South Dakota 66000 30000 230000 235000 28 12500 5
2020 July-September Tennessee 2200 460 15000 15000 15 860 6
2020 July-September Texas 9500 9000 167000 173000 5 7500 4
2020 July-September Utah 2000 1500 24000 30000 7 2300 8
2020 July-September Vermont 210 700 7500 7500 3 180 2
2020 July-September Virginia 1200 910 8500 8500 14 730 9
2020 July-September Washington 7000 5000 94000 104000 7 8500 8
2020 July-September West Virginia 540 210 8000 8000 7 800 10
2020 July-September Wisconsin 8000 970 68000 68000 12 9000 13
2020 July-September Wyoming 3600 640 33000 34000 11 7500 22
2020 July-September Other States 2080 2230 10630 11630 18 700 6
2020 July-September United States 411490 348280 3175330 NA 13 381620 12
2020 October-December Alabama 1100 750 17000 17000 6 60 NA
2020 October-December Arizona 4000 5500 25000 27000 15 600 2
2020 October-December Arkansas 2100 380 22000 23000 9 780 3
2020 October-December California 164000 120000 700000 1400000 12 58000 4
2020 October-December Colorado 5000 930 19000 19000 26 20 NA
2020 October-December Connecticut 500 20 4300 4600 11 20 NA
2020 October-December Florida 29000 50000 240000 290000 10 17500 6
2020 October-December Georgia 30000 11000 165000 174000 17 11000 6
2020 October-December Hawaii 2700 200 22000 22000 12 370 2
2020 October-December Idaho 19000 8000 94000 180000 11 1700 1
2020 October-December Illinois 1700 330 13000 13000 13 410 3
2020 October-December Indiana 930 240 10000 11000 8 260 2
2020 October-December Iowa 4800 700 38000 38000 13 850 2
2020 October-December Kansas 2400 460 6000 7000 34 170 2
2020 October-December Kentucky 1100 380 11500 11500 10 520 5
2020 October-December Louisiana 1700 30 46000 52000 3 620 1
2020 October-December Maine 100 180 9000 9000 1 250 3
2020 October-December Maryland 980 60 6000 8000 12 460 6
2020 October-December Massachusetts 390 270 10000 10000 4 90 1
2020 October-December Michigan 10500 2400 97000 101000 10 1600 2
2020 October-December Minnesota 9500 1200 99000 105000 9 340 NA
2020 October-December Mississippi 3800 300 30000 37000 10 30 NA
2020 October-December Missouri 750 20 6500 7000 11 110 2
2020 October-December Montana 14000 3500 81000 92000 15 290 NA
2020 October-December Nebraska 7000 280 43000 43000 16 2500 6
2020 October-December New Jersey 310 2000 18000 18000 2 480 3
2020 October-December New Mexico 190 80 2400 3600 5 50 1
2020 October-December New York 4100 2400 52000 52000 8 5000 10
2020 October-December North Carolina 2500 200 16500 22000 11 9000 41
2020 October-December North Dakota 45000 12500 445000 445000 10 NA NA
2020 October-December Ohio 1600 10 21000 21000 8 490 2
2020 October-December Oklahoma 300 250 7000 28000 1 NA NA
2020 October-December Oregon 15500 7000 122000 123000 13 2600 2
2020 October-December Pennsylvania 1900 580 23000 25000 8 440 2
2020 October-December South Carolina 2600 270 11500 18500 14 210 1
2020 October-December South Dakota 16000 1000 197000 197000 8 150 NA
2020 October-December Tennessee 680 20 13500 13500 5 640 5
2020 October-December Texas 43000 27000 144000 255000 17 1700 1
2020 October-December Utah 3800 1800 29000 29000 13 50 NA
2020 October-December Vermont 270 30 8000 8000 3 NA NA
2020 October-December Virginia 1000 70 8000 8500 12 450 5
2020 October-December Washington 16500 6000 102000 103000 16 2000 2
2020 October-December West Virginia 550 120 7500 7500 7 800 11
2020 October-December Wisconsin 8000 2800 60000 60000 13 4700 8
2020 October-December Wyoming 1600 160 23000 25000 6 380 2
2020 October-December Other States 2470 80 10640 10740 23 1300 12
2020 October-December United States 484920 271500 3135340 NA 15 128990 4
2021 January-March Alabama 1200 670 10000 10000 12 200 2
2021 January-March Arizona 7000 3500 29000 29000 24 180 1
2021 January-March Arkansas 2200 790 21000 21000 10 130 1
2021 January-March California 193000 76000 1240000 1550000 12 84000 5
2021 January-March Colorado 640 850 3000 16500 4 30 NA
2021 January-March Connecticut 780 350 4200 4200 19 50 1
2021 January-March Florida 31000 42000 300000 305000 10 17000 6
2021 January-March Georgia 20000 34000 120000 120000 17 14500 12
2021 January-March Hawaii 900 2400 19500 19500 5 1600 8
2021 January-March Idaho 15000 9000 168000 171000 9 8500 5
2021 January-March Illinois 3000 3300 9500 12500 24 200 2
2021 January-March Indiana 2700 3500 10000 11000 25 20 NA
2021 January-March Iowa 2100 3100 15000 25000 8 30 NA
2021 January-March Kansas 1400 2300 5000 6500 22 10 NA
2021 January-March Kentucky 2100 2500 9500 9500 22 80 1
2021 January-March Louisiana 7500 1100 51000 53000 14 3000 6
2021 January-March Maine 300 60 2900 2900 10 80 3
2021 January-March Maryland 1200 590 7000 7000 17 240 3
2021 January-March Massachusetts 1000 30 5000 5000 20 90 2
2021 January-March Michigan 1500 320 78000 78000 2 4100 5
2021 January-March Minnesota 3200 2900 41000 68000 5 140 NA
2021 January-March Mississippi 5500 14500 33000 36000 15 3800 11
2021 January-March Missouri 1500 780 5500 5500 27 40 1
2021 January-March Montana 310 NA 40000 51000 1 20 NA
2021 January-March Nebraska 640 1300 11000 17500 4 NA NA
2021 January-March New Jersey 360 610 14000 14000 3 80 1
2021 January-March New Mexico 230 2200 3500 3500 7 NA NA
2021 January-March New York 4900 3400 30000 30000 16 380 1
2021 January-March North Carolina 2100 2700 18000 21000 10 110 1
2021 January-March North Dakota 180 2700 51000 65000 NA NA NA
2021 January-March Ohio 4000 120 17500 17500 23 20 NA
2021 January-March Oklahoma 2600 4100 28000 28000 9 360 1
2021 January-March Oregon 3100 2600 76000 79000 4 610 1
2021 January-March Pennsylvania 5500 4100 20000 21000 26 40 NA
2021 January-March South Carolina 1200 930 15500 18500 6 190 1
2021 January-March South Dakota 450 NA 28000 34000 1 NA NA
2021 January-March Tennessee 2200 960 12000 13000 17 310 2
2021 January-March Texas 23000 56000 240000 345000 7 13000 4
2021 January-March Utah 2500 4000 17500 18500 14 NA NA
2021 January-March Vermont 1300 670 7500 7500 17 70 1
2021 January-March Virginia 1400 2300 7000 7000 20 50 1
2021 January-March Washington 6000 5500 48000 67000 9 850 1
2021 January-March West Virginia 1200 1700 7000 7500 16 720 10
2021 January-March Wisconsin 2500 7000 25000 37000 7 170 NA
2021 January-March Wyoming 1700 500 13000 14500 12 1200 8
2021 January-March Other States 540 600 6640 6640 8 70 1
2021 January-March United States 372630 308530 2923240 NA 13 156270 5
2021 April-June Alabama 2700 2800 9500 9500 28 930 10
2021 April-June Arizona 4200 8500 26000 26000 16 7500 29
2021 April-June Arkansas 1600 9000 12000 12000 13 6000 50
2021 April-June California 64000 200000 1050000 1060000 6 180000 17
2021 April-June Colorado 5500 4800 17000 22000 25 1100 5
2021 April-June Connecticut 60 960 3800 4000 2 400 10
2021 April-June Florida 33000 52000 300000 300000 11 31000 10
2021 April-June Georgia 20000 25000 135000 136000 15 18500 14
2021 April-June Hawaii 630 460 21000 21000 3 1200 6
2021 April-June Idaho 19500 40000 86000 120000 16 19000 16
2021 April-June Illinois 1100 3700 13000 13000 8 2100 16
2021 April-June Indiana 560 4000 12000 12500 4 1000 8
2021 April-June Iowa 2200 10500 26000 27000 8 3900 14
2021 April-June Kansas 870 4900 7500 8000 11 1600 20
2021 April-June Kentucky 270 2100 10000 11500 2 4500 39
2021 April-June Louisiana 2300 8000 29000 30000 8 2000 7
2021 April-June Maine 1100 430 2000 18000 6 260 1
2021 April-June Maryland 320 2600 6500 7500 4 690 9
2021 April-June Massachusetts 810 1400 4000 10000 8 310 3
2021 April-June Michigan 3500 10000 75000 97000 4 8000 8
2021 April-June Minnesota 5500 28000 69000 98000 6 4000 4
2021 April-June Mississippi 4800 9000 34000 35000 14 8000 23
2021 April-June Missouri 670 2000 4800 4800 14 670 14
2021 April-June Montana 3100 13500 38000 116000 3 15500 13
2021 April-June Nebraska 1800 8500 18500 37000 5 810 2
2021 April-June New Jersey 410 1400 14500 19500 2 140 1
2021 April-June New Mexico 540 80 5500 5500 10 2300 42
2021 April-June New York 3000 14500 29000 50000 6 4100 8
2021 April-June North Carolina 1700 6000 22000 23000 7 3300 14
2021 April-June North Dakota 4400 4800 42000 395000 1 3500 1
2021 April-June Ohio 820 6500 13000 13500 6 2400 18
2021 April-June Oklahoma 3600 4200 17000 17000 21 190 1
2021 April-June Oregon 3300 25000 80000 84000 4 19500 23
2021 April-June Pennsylvania 2100 7000 20000 23000 9 2800 12
2021 April-June South Carolina 1800 4100 18500 19500 9 5000 26
2021 April-June South Dakota 6500 39000 16500 198000 3 19000 10
2021 April-June Tennessee 720 4800 12000 12000 6 3400 28
2021 April-June Texas 34000 65000 385000 425000 8 72000 17
2021 April-June Utah 3500 8500 20000 31000 11 3900 13
2021 April-June Vermont 40 770 7000 7000 1 570 8
2021 April-June Virginia 530 3100 8000 8500 6 820 10
2021 April-June Washington 2900 9500 66000 122000 2 2600 2
2021 April-June West Virginia 170 1900 8000 9000 2 390 4
2021 April-June Wisconsin 2200 9000 42000 57000 4 7500 13
2021 April-June Wyoming 3400 7500 13500 30000 11 4900 16
2021 April-June Other States 140 2890 5970 8410 2 3100 37
2021 April-June United States 255860 677690 2855070 NA 9 480380 17

Bee Balance

We focused on our variable: “bee_blance”:

Code 
#Compute bee balance
data <- colony %>%
  mutate(quarterly_bee_balance = colony_added - colony_lost) %>%
  group_by(year, state) %>%
  summarize(bee_balance = sum(quarterly_bee_balance, na.rm = TRUE),
            bee_lost = sum(colony_lost, na.rm = TRUE),
            bee_gained = sum(colony_added, na.rm = TRUE)) %>%
  ungroup

#Compute total bee balance
data <- data %>%
  arrange(state) %>%
  group_by(state) %>%
  mutate(bee_balance_state = sum(bee_balance)) %>%
  ungroup()

#Table of sum(added - lost) per state
knitr::kable(data %>% 
  relocate(bee_lost, bee_gained, bee_balance, bee_balance_state, .after = state))
year state bee_lost bee_gained bee_balance bee_balance_state
2015 Alabama 4670 4940 270 -4640
2016 Alabama 4440 2890 -1550 -4640
2017 Alabama 3930 3010 -920 -4640
2018 Alabama 4160 4310 150 -4640
2019 Alabama 2300 1200 -1100 -4640
2020 Alabama 9310 8250 -1060 -4640
2021 Alabama 3900 3470 -430 -4640
2015 Arizona 28100 30200 2100 2290
2016 Arizona 20900 24000 3100 2290
2017 Arizona 19200 21700 2500 2290
2018 Arizona 21600 18210 -3390 2290
2019 Arizona 11500 6230 -5270 2290
2020 Arizona 19800 22250 2450 2290
2021 Arizona 11200 12000 800 2290
2015 Arkansas 14800 15100 300 -4640
2016 Arkansas 12400 16990 4590 -4640
2017 Arkansas 18900 12330 -6570 -4640
2018 Arkansas 17300 17250 -50 -4640
2019 Arkansas 10200 620 -9580 -4640
2020 Arkansas 6900 7580 680 -4640
2021 Arkansas 3800 9790 5990 -4640
2015 California 584000 499000 -85000 -145000
2016 California 605000 488000 -117000 -145000
2017 California 476000 588000 112000 -145000
2018 California 533000 525000 -8000 -145000
2019 California 464000 330000 -134000 -145000
2020 California 537000 605000 68000 -145000
2021 California 257000 276000 19000 -145000
2015 Colorado 10400 11000 600 -26290
2016 Colorado 13370 12600 -200 -26290
2017 Colorado 15900 10000 -5900 -26290
2018 Colorado 15700 12770 -2930 -26290
2019 Colorado 17820 3300 -14200 -26290
2020 Colorado 14750 11580 -3170 -26290
2021 Colorado 6140 5650 -490 -26290
2015 Connecticut 1210 1620 410 3130
2016 Connecticut 880 1350 710 3130
2017 Connecticut 980 2540 1560 3130
2018 Connecticut 610 640 250 3130
2019 Connecticut 770 250 -520 3130
2020 Connecticut 1160 1410 250 3130
2021 Connecticut 840 1310 470 3130
2015 Florida 150000 165000 15000 263000
2016 Florida 140000 172000 32000 263000
2017 Florida 144000 214000 70000 263000
2018 Florida 156000 217000 61000 263000
2019 Florida 96000 115000 19000 263000
2020 Florida 127000 163000 36000 263000
2021 Florida 64000 94000 30000 263000
2015 Georgia 68500 95900 27400 101200
2016 Georgia 55000 70000 15000 101200
2017 Georgia 61000 80300 19300 101200
2018 Georgia 77500 96500 19000 101200
2019 Georgia 47500 42000 -5500 101200
2020 Georgia 77500 84500 7000 101200
2021 Georgia 40000 59000 19000 101200
2015 Hawaii 3890 8400 4510 6290
2016 Hawaii 2680 1930 -750 6290
2017 Hawaii 1480 2430 950 6290
2018 Hawaii 4620 4900 280 6290
2019 Hawaii 1890 1160 -730 6290
2020 Hawaii 4740 5440 700 6290
2021 Hawaii 1530 2860 1330 6290
2015 Idaho 46200 30100 -16100 -41200
2016 Idaho 41000 31400 -9600 -41200
2017 Idaho 39000 45000 6000 -41200
2018 Idaho 55800 43500 -12300 -41200
2019 Idaho 38500 14900 -23600 -41200
2020 Idaho 63000 62900 -100 -41200
2021 Idaho 34500 49000 14500 -41200
2015 Illinois 7590 9600 2700 3000
2016 Illinois 4060 3520 180 3000
2017 Illinois 7000 7550 550 3000
2018 Illinois 6560 7000 440 3000
2019 Illinois 4940 1670 -3270 3000
2020 Illinois 6700 6200 -500 3000
2021 Illinois 4100 7000 2900 3000
2015 Indiana 6100 6930 830 4330
2016 Indiana 2790 3210 420 4330
2017 Indiana 5730 5440 -290 4330
2018 Indiana 7090 4860 -2230 4330
2019 Indiana 3010 2800 -210 4330
2020 Indiana 5050 6620 1570 4330
2021 Indiana 3260 7500 4240 4330
2015 Iowa 11800 8880 -2920 45810
2016 Iowa 15800 36590 25490 45810
2017 Iowa 13700 26420 12720 45810
2018 Iowa 13400 17750 4350 45810
2019 Iowa 12500 3670 -8830 45810
2020 Iowa 11800 17500 5700 45810
2021 Iowa 4300 13600 9300 45810
2015 Kansas 6670 3400 -3270 -2420
2016 Kansas 5840 3510 -1350 -2420
2017 Kansas 3910 4970 1060 -2420
2018 Kansas 3070 3020 -50 -2420
2019 Kansas 4050 750 -3300 -2420
2020 Kansas 4500 4060 -440 -2420
2021 Kansas 2270 7200 4930 -2420
2015 Kentucky 7480 4040 -3440 -3550
2016 Kentucky 3700 3170 -530 -3550
2017 Kentucky 4330 4350 20 -3550
2018 Kentucky 4890 2280 -2610 -3550
2019 Kentucky 2150 950 -1200 -3550
2020 Kentucky 4900 6880 1980 -3550
2021 Kentucky 2370 4600 2230 -3550
2015 Louisiana 16700 13000 -3700 11000
2016 Louisiana 22800 20350 -2450 11000
2017 Louisiana 21500 30490 8990 11000
2018 Louisiana 9070 12830 3760 11000
2019 Louisiana 9900 13470 3570 11000
2020 Louisiana 10900 12430 1530 11000
2021 Louisiana 9800 9100 -700 11000
2015 Maine 4090 4460 370 -11610
2016 Maine 5070 750 -3870 -11610
2017 Maine 2370 1320 -1050 -11610
2018 Maine 3630 740 -2890 -11610
2019 Maine 2340 580 -1760 -11610
2020 Maine 3030 1400 -1500 -11610
2021 Maine 1400 490 -910 -11610
2015 Maryland 5880 4930 -220 4370
2016 Maryland 2420 3260 840 4370
2017 Maryland 5190 5290 100 4370
2018 Maryland 2920 3040 1620 4370
2019 Maryland 4190 1140 -3050 4370
2020 Maryland 2990 5760 3410 4370
2021 Maryland 1520 3190 1670 4370
2015 Massachusetts 2140 1520 -620 -4270
2016 Massachusetts 1940 1670 470 -4270
2017 Massachusetts 3490 2930 -560 -4270
2018 Massachusetts 4110 2110 -2000 -4270
2019 Massachusetts 2980 920 -2060 -4270
2020 Massachusetts 1810 2690 880 -4270
2021 Massachusetts 1810 1430 -380 -4270
2015 Michigan 37000 24510 -12490 -37750
2016 Michigan 40000 26810 -13190 -37750
2017 Michigan 38600 27890 -10710 -37750
2018 Michigan 28000 35400 7400 -37750
2019 Michigan 24000 3820 -13680 -37750
2020 Michigan 53100 52700 -400 -37750
2021 Michigan 5000 10320 5320 -37750
2015 Minnesota 58200 21930 -36270 -59290
2016 Minnesota 58500 29700 -15300 -59290
2017 Minnesota 35500 25600 -9900 -59290
2018 Minnesota 50900 63600 12700 -59290
2019 Minnesota 38700 8480 -30220 -59290
2020 Minnesota 27500 25000 -2500 -59290
2021 Minnesota 8700 30900 22200 -59290
2015 Mississippi 24500 28260 3760 64010
2016 Mississippi 15900 21080 5180 64010
2017 Mississippi 12700 29030 16330 64010
2018 Mississippi 11900 32340 20440 64010
2019 Mississippi 8700 4700 -4000 64010
2020 Mississippi 13400 22500 9100 64010
2021 Mississippi 10300 23500 13200 64010
2015 Missouri 4390 2850 -1540 -2680
2016 Missouri 3210 4610 1400 -2680
2017 Missouri 2860 2520 -340 -2680
2018 Missouri 3210 3630 420 -2680
2019 Missouri 3100 600 -2500 -2680
2020 Missouri 3970 3240 -730 -2680
2021 Missouri 2170 2780 610 -2680
2015 Montana 26900 19600 -7300 -19140
2016 Montana 35340 43300 7960 -19140
2017 Montana 35770 26700 -9070 -19140
2018 Montana 28940 33040 4100 -19140
2019 Montana 29000 6070 -22930 -19140
2020 Montana 26450 24000 -2300 -19140
2021 Montana 3410 13500 10400 -19140
2015 Nebraska 19700 16130 -3570 -16650
2016 Nebraska 19130 8620 -10510 -16650
2017 Nebraska 12590 7080 -5510 -16650
2018 Nebraska 14630 18600 4400 -16650
2019 Nebraska 8900 1000 -5400 -16650
2020 Nebraska 13770 10350 -3420 -16650
2021 Nebraska 2440 9800 7360 -16650
2015 New Jersey 3380 2880 -500 70
2016 New Jersey 3110 2500 -610 70
2017 New Jersey 2540 2220 -320 70
2018 New Jersey 2620 1660 -960 70
2019 New Jersey 1210 840 -370 70
2020 New Jersey 3620 5210 1590 70
2021 New Jersey 770 2010 1240 70
2015 New Mexico 3580 3280 -300 1250
2016 New Mexico 5800 5810 10 1250
2017 New Mexico 8200 9400 1200 1250
2018 New Mexico 8150 4320 -3830 1250
2019 New Mexico 410 1030 790 1250
2020 New Mexico 1880 3750 1870 1250
2021 New Mexico 770 2280 1510 1250
2015 New York 18100 16090 -2010 -22420
2016 New York 27000 15780 -11220 -22420
2017 New York 17700 20440 2740 -22420
2018 New York 15300 13000 -2300 -22420
2019 New York 21900 3940 -17960 -22420
2020 New York 16300 14630 -1670 -22420
2021 New York 7900 17900 10000 -22420
2015 North Carolina 13900 14510 610 -1440
2016 North Carolina 11000 11700 700 -1440
2017 North Carolina 12400 11760 -640 -1440
2018 North Carolina 10300 8850 -1450 -1440
2019 North Carolina 7600 2790 -4810 -1440
2020 North Carolina 10900 10150 -750 -1440
2021 North Carolina 3800 8700 4900 -1440
2015 North Dakota 157620 54500 -103120 -359340
2016 North Dakota 159000 61500 -80500 -359340
2017 North Dakota 85140 54600 -30540 -359340
2018 North Dakota 102200 63100 -39100 -359340
2019 North Dakota 109100 18000 -90000 -359340
2020 North Dakota 120000 101000 -19000 -359340
2021 North Dakota 4580 7500 2920 -359340
2015 Ohio 16900 17500 600 1520
2016 Ohio 9600 7760 -1840 1520
2017 Ohio 10100 10910 810 1520
2018 Ohio 8500 10770 2270 1520
2019 Ohio 7800 5300 -2500 1520
2020 Ohio 10700 11080 380 1520
2021 Ohio 4820 6620 1800 1520
2015 Oklahoma 9080 8550 -530 20800
2016 Oklahoma 6470 4210 -2260 20800
2017 Oklahoma 1360 16120 14760 20800
2018 Oklahoma 8170 9970 1800 20800
2019 Oklahoma 3480 610 -2870 20800
2020 Oklahoma 3600 11400 7800 20800
2021 Oklahoma 6200 8300 2100 20800
2015 Oregon 29000 27000 -2000 27720
2016 Oregon 24100 27200 3100 27720
2017 Oregon 36500 33070 -3430 27720
2018 Oregon 33500 53500 20000 27720
2019 Oregon 30500 14650 -15850 27720
2020 Oregon 34800 39500 4700 27720
2021 Oregon 6400 27600 21200 27720
2015 Other States 6550 6160 -390 -5070
2016 Other States 4470 5040 570 -5070
2017 Other States 3120 1530 -1590 -5070
2018 Other States 4170 2540 -1630 -5070
2019 Other States 4010 670 -3340 -5070
2020 Other States 5240 3740 -1500 -5070
2021 Other States 680 3490 2810 -5070
2015 Pennsylvania 12400 11960 -440 10060
2016 Pennsylvania 8600 7520 -1080 10060
2017 Pennsylvania 11710 16310 4600 10060
2018 Pennsylvania 7460 10770 3310 10060
2019 Pennsylvania 7680 3770 -3910 10060
2020 Pennsylvania 6100 10180 4080 10060
2021 Pennsylvania 7600 11100 3500 10060
2015 South Carolina 7850 5320 -2530 2120
2016 South Carolina 6920 6050 -870 2120
2017 South Carolina 6170 8540 2370 2120
2018 South Carolina 6000 5740 -260 2120
2019 South Carolina 4790 5400 610 2120
2020 South Carolina 6900 7670 770 2120
2021 South Carolina 3000 5030 2030 2120
2015 South Dakota 87600 40000 -47600 -162460
2016 South Dakota 47770 19230 -17540 -162460
2017 South Dakota 31700 17500 -7700 -162460
2018 South Dakota 55390 31250 -24140 -162460
2019 South Dakota 59600 1300 -49700 -162460
2020 South Dakota 87800 39520 -48280 -162460
2021 South Dakota 6950 39000 32500 -162460
2015 Tennessee 5030 5170 140 -4570
2016 Tennessee 4070 4460 390 -4570
2017 Tennessee 5700 5130 -570 -4570
2018 Tennessee 7000 4370 -2630 -4570
2019 Tennessee 7300 2460 -4840 -4570
2020 Tennessee 5580 5680 100 -4570
2021 Tennessee 2920 5760 2840 -4570
2015 Texas 100500 176500 76000 583400
2016 Texas 116000 161700 45700 583400
2017 Texas 88000 215200 127200 583400
2018 Texas 77500 236500 159000 583400
2019 Texas 45500 75500 30000 583400
2020 Texas 112500 194000 81500 583400
2021 Texas 57000 121000 64000 583400
2015 United States 1722360 1498980 -223380 96100
2016 United States 1658260 1457060 -201200 96100
2017 United States 1407200 1728590 321390 96100
2018 United States 1517070 1721790 204720 96100
2019 United States 1241910 733520 -508390 96100
2020 United States 1548610 1693840 145230 96100
2021 United States 628490 986220 357730 96100
2015 Utah 16600 14020 -2580 20340
2016 Utah 11300 14350 3050 20340
2017 Utah 13500 23380 9880 20340
2018 Utah 10120 11640 1520 20340
2019 Utah 9000 5370 -3630 20340
2020 Utah 8900 14500 5600 20340
2021 Utah 6000 12500 6500 20340
2015 Vermont 1780 1820 40 3060
2016 Vermont 1090 670 -10 3060
2017 Vermont 1260 920 100 3060
2018 Vermont 1350 3830 2480 3060
2019 Vermont 570 230 -340 3060
2020 Vermont 1260 1430 690 3060
2021 Vermont 1340 1440 100 3060
2015 Virginia 4200 3420 -30 5160
2016 Virginia 2870 3390 520 5160
2017 Virginia 4700 5730 1030 5160
2018 Virginia 4300 4020 -280 5160
2019 Virginia 2870 440 -2430 5160
2020 Virginia 4500 7380 2880 5160
2021 Virginia 1930 5400 3470 5160
2015 Washington 37000 30630 -6370 -10380
2016 Washington 33000 35800 2800 -10380
2017 Washington 36500 52900 16400 -10380
2018 Washington 34100 38500 4400 -10380
2019 Washington 40500 18310 -22190 -10380
2020 Washington 28100 16580 -11520 -10380
2021 Washington 8900 15000 6100 -10380
2015 West Virginia 3280 3960 680 -960
2016 West Virginia 3880 2810 630 -960
2017 West Virginia 3270 4360 1090 -960
2018 West Virginia 4210 2650 -1560 -960
2019 West Virginia 3900 250 -3650 -960
2020 West Virginia 2760 2380 -380 -960
2021 West Virginia 1370 3600 2230 -960
2015 Wisconsin 28100 14610 -13490 -45140
2016 Wisconsin 27900 18920 -8980 -45140
2017 Wisconsin 28300 19980 -8320 -45140
2018 Wisconsin 29100 19300 -9800 -45140
2019 Wisconsin 18700 4780 -13920 -45140
2020 Wisconsin 19200 17270 -1930 -45140
2021 Wisconsin 4700 16000 11300 -45140
2015 Wyoming 9000 9800 800 -11670
2016 Wyoming 12140 9350 -2450 -11670
2017 Wyoming 13700 11700 -2000 -11670
2018 Wyoming 9020 5190 -3830 -11670
2019 Wyoming 6550 2600 -3700 -11670
2020 Wyoming 6940 3550 -3390 -11670
2021 Wyoming 5100 8000 2900 -11670

Plot 1: Bee Balance Overall

= Kirstines plot

Code 
#To make a dataset with only dat for the entire US 
colony_balance <- colony %>% 
  mutate(bee_balance = colony_added - colony_lost)

US_total <- colony_balance %>%  
  filter(state == "United States")

#We want to plot year as a continous variable with the month data 
US_total$months_num <- recode(US_total$months, "January-March" = 0,     
                              "April-June" = 0.25,
                              "July-September" = 0.5,
                              "October-December" = 0.75)

#new column with the year and month merged 
US_total_new_month <- US_total %>% 
  mutate(year_month = (year + months_num))

#Plot with lost bees accumulation
G1 <- US_total_new_month %>% 
  ggplot(aes(year_month, cumsum(replace_na(colony_lost, 0))/1e6)) +
  geom_line(color = "red") +
  theme_minimal(base_size = 14) +
  labs(x = "Year",
       y =  "Colonies Lost (Millions)") +
  ggtitle("Lost Bee Colonies in The US") +
  scale_y_continuous(breaks = c(0:10), 
                     labels = label_comma()) +
  scale_x_continuous(breaks = c(2015:2021), minor_breaks = seq(2015, 2021, 0.25))

#Plot with added bees accumulation
G2 <- US_total_new_month %>% 
  ggplot(aes(year_month, cumsum(replace_na(colony_added, 0))/1e6)) +
  geom_line(color = "green") +
  theme_minimal(base_size = 14) +
  labs(x = "Year",
       y =  "Colonies Added (Millions)") +
  ggtitle("Added Bee Colonies in The US") +
  scale_y_continuous(breaks = c(0:10), 
                     labels = label_comma()) +
  scale_x_continuous(breaks = c(2015:2021), minor_breaks = seq(2015, 2021, 0.25))

ggarrange(G1, G2)

Code 
#% colonies lost
US_total_new_month %>% 
  ggplot(aes(year_month, colony_lost_pct, fill = months)) +
  geom_col(color = "yellow") +
  theme_minimal(base_size = 16) +
  scale_x_continuous(breaks = c(2015:2021)) +
  scale_y_continuous(breaks = seq(0, 20, 5), limits = c(0, 20)) +
  labs(x = "Year",
       y =  "Colonies lost (%)",
       fill = "Month") +
  ggtitle("Lost Bee Colonies in The United States")

Code 
#Plot of the Bee balance in the US during the years 
US_total_new_month %>% 
  ggplot(aes(year_month, bee_balance)) +
  geom_line() +
  theme_minimal(base_size = 16) +
  labs(x = "Year",
       y =  "Bee Balance") +
  ggtitle("Bee Balance in The US") +
  geom_hline(yintercept = 0, linetype = "dashed", color = "black") + 
  scale_y_continuous(breaks = c(-600000, -400000, -200000, 0,200000, 400000, 600000), 
                     limits = c(-400000, 500000), 
                     labels = label_comma()) +
  scale_x_continuous(breaks = c(2015:2021), minor_breaks = seq(2015, 2021, 0.25))

Plot 2: Bee Balance per State

Code 
temp <- data %>%
  filter(state != "United States")

ggplot(data = temp, aes(x = year, y = bee_balance, color = bee_balance_state)) + 
  geom_line(size= 1) +
  facet_wrap(~state, nrow = 6) +
  theme_minimal() +
  scale_color_gradient(low = "black", high = "yellow",
                      name = "Bee balance", label = scales::comma) + 
  labs(x = "Year",
       y = "Yearly balance") +
  scale_x_continuous(breaks = c(2016,2018,2020), 
                     minor_breaks = seq(2015, 2021, 1)) +
  scale_y_continuous(label = scales::comma) +
   geom_hline(yintercept=0, linetype="dashed", color = "red") +
  theme(
   axis.text.x = element_text(angle=45))

Plot 3: Bee Balance on Choropleth Map

Code 
plot_usmap(data = data, values = "bee_balance", color = "black",
           exclude = c("Alaska", "Nevada", "New Hampshire", "Delaware", "Rhode Island", "District of Columbia")) +
  scale_fill_continuous(low = "black", high = "yellow",
                        name = "Bee balance", label = scales::comma)  + 
  facet_wrap(~year, nrow = 3) +
  theme(axis.text.y = element_blank()) +
  theme_void()

Code for Animated Choropleth Map

Create data frame for time series

Code 
# Libraries
library(pacman)
pacman::p_load(tidyverse, sf, ggrepel, gganimate, gifski, ggpubr, scales, zoo)
package 'lpSolve' successfully unpacked and MD5 sums checked
package 'transformr' successfully unpacked and MD5 sums checked
package 'tweenr' successfully unpacked and MD5 sums checked
package 'gganimate' successfully unpacked and MD5 sums checked

The downloaded binary packages are in
    C:\Users\au555953\AppData\Local\Temp\RtmpqYyV05\downloaded_packages
package 'gifski' successfully unpacked and MD5 sums checked

The downloaded binary packages are in
    C:\Users\au555953\AppData\Local\Temp\RtmpqYyV05\downloaded_packages
Code 
# Load data: Bee colonies lost
colony <- readr::read_csv('https://raw.githubusercontent.com/rfordatascience/tidytuesday/master/data/2022/2022-01-11/colony.csv')

# Compute "bee-balance" per state per year
bee_balance <- colony %>% 
  filter(state != "United States" & state != "Other States") %>% 
  group_by(year, state) %>% 
  summarise(year_balance = sum(colony_added - colony_lost, na.rm = TRUE))

# Create shape file (sf) object 
usa_sf <- read_sf("usa.json")
usa_sf <- usa_sf %>% 
  rename(state = NAME)

# Merge with bee data: 
usa_sf_merged <- usa_sf %>%
  left_join(bee_balance, by = "state") %>% 
  filter(state != "Alaska")   # no data for Alaska

# Create State Names
coordinates_state_names <- data.frame(state = usa_sf_merged$state, 
                                      coordinates = usa_sf_merged$geometry) %>% 
  distinct() %>% 
  filter(state %in% c("Texas", "California", "Florida", "North Dakota"))

Code for Animated Choropleth Maps cont.

Code 
# Choropleth map:
map <- ggplot(usa_sf_merged) +
  geom_sf(aes(fill = year_balance), linewidth = 0, alpha = 0.9) +
  ggrepel::geom_label_repel(
    data = coordinates_state_names,
    aes(label = state, geometry = geometry),
    stat = "sf_coordinates",
    min.segment.length = 0, 
    force = 300,
    seed = 8, 
    size = 7
  ) +
  theme_void(
    base_size = 16
  ) +
  scale_fill_gradient2() +
  labs(title = "Bee Balance in {round(frame_time)}", 
       fill = "Balance") +
  theme(
    text = element_text(color = "#22211d"),
    plot.background = element_rect(fill = "#f5f5f2", color = NA),
    panel.background = element_rect(fill = "#f5f5f2", color = NA),
    legend.background = element_rect(fill = "#f5f5f2", color = NA),
    plot.title = element_text(
      size = 32, hjust = 0.01, color = "#4e4d47",
      margin = margin(b = -0.1, t = 0.4, l = 2, unit = "cm")
    )
  ) + 
  transition_time(year)

# map_anim1 <- animate(map, fps = 10, height = 974, width = 1275, renderer = gifski_renderer())

# anim_save("bee_balance_years.gif", map_anim1)